I am trying to setup a Conditional Format formula to format a cell only when the cell contains a linked value of "Sheet Link from Cell in Other Sheet"
Shortest answer is to use a hidden helper column. Make a new column name it hidden and post the cell link at the top. Use an if statement, =if(columnheaderhere@row=$hidden$1,1,0 then use the conditional formatting tool to check if there is a 1 in the hidden column. When you are done simply hide the column.
GL
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
Hello, The SmartSheet seems to be locked with predecessors dependencies not updating start date of activities. Also the duration does not seem to update the end date. So all needs to be done manually. This was working last week but seems deactivated. How can I reactivate it? Thanks
