Dan PalencharSep 3, 20211 min readHow to make Smartsheet bar charts with multiple colors based on value#Smartsheet #ProjectManagement #SolutionsArchitecture #Dashboards A user in the Smartsheet community asked how he can change colors in a...
Dan PalencharDec 28, 20201 min readSmartsheet Formulas Tutorial | COUNTIFS with ISDATE and ISBLANKABOUT THIS VIDEO In this video, I answer a question from the Smartsheet Community. A user wants to count rows that meet only certain...
Dan PalencharDec 7, 20201 min readHow to use the Smartsheet Document BuilderJoin School of Sheets for a comprehensive walkthrough of one of the newest features in Smartsheet, Document Builder. Be sure to check out...
Dan PalencharSep 29, 20201 min readWorking with % Complete in Smartsheet#Smartsheet #ProjectManagement #RemoteWork In this video, I'll show you different ways to determine the percent complete at the project...
Dan PalencharAug 31, 20201 min readSmartsheet Automation | Populate a date field based on status changeIn this video you'll learn how to automatically populate a date field with the data a specific status change was made. In this scenario,...
Dan PalencharAug 18, 20201 min readSmartsheet Formula Tutorial | Use nested IF/OR statement to return a region based on state.In this video I answer a question from the Smartsheet Community. A user is trying to make a formula that will evaluate a State in a cell...