Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days?
Thanks!
What kind of sheet / template are you working with? Are you trying to use dependencies?
For progress column, I want to use the symbol column with bar option (Empty, Quarter, Half, Three Quarter, Full) and it should be driven by task % Complete. if % Complete Value is 0% then progress should be Empty, if complete value is between 0 - 35% then progress should be Quarter, if value is between 36-65% then progress…
I have a contact sheet and a main sheet. There are instances when I have 2-3 individuals that need to be notified based on the information on the main sheet. I created this formula to pull multiple emails from the contact list: =JOIN(COLLECT({Department Chairs}, {CourseName}, CONTAINS([APA Courses]@row , @cell )),…
Hi everyone, I’m rebuilding an Operational Status formula that references another sheet for quarter-end deadlines. The formula works logically, but Smartsheet keeps returning #UNPARSEABLE. Here’s the current version (I’ve confirmed all range names and column types are correct): =IF( AND( OR([Step 1: CQ LAUNCH Required (Yes…
