I am using smartsheets to track time expended on multiple projects and need to conditionally format a cell based on a variable value in a specific cell.
You would need to include a helper column with a formula that flags rows that are too low. You would then set up your conditional formatting to be based on the helper column.
Yes, this was the work around I had to do. Unnecessary extra steps and somewhat ruins my beautiful report, but it worked..
You can hide the helper column to help keep the sheet looking clean.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello, Please help and thanks in advance. I am trying to Count all the Key-User cells with a checkbox where the branch is MIL. I have tried the below formula but keep getting #UNPARSEABLE. Formula I tried is =COUNTIF([Key-User]:[Key-User], =1), CONTAINS ("MIL",@cell,[Branch;Branch]) Also tried…
Hi, I'm unable to get countifs results on this sheet where GEO is drop-down list column allowing for multi values and STATUS is a drop-down list allowing single values. I'm looking to count the number of values GEO if the STATUS is COMPLETE. In this case: EU, COMPLETE (2) US, COMPLETE (1) AFR, COMPLETE (1) Any idea how to…
We have lot of tasks completed on different months on that how to calculate number of tasks completed on specific month for example on Month July 2023 with a condition that value shows Current=YES.
©2023. All Rights Reserved Smartsheet Inc.