I keep getting an error with my IF formula. I want it to read:
IF this cell says "Yes" and this cell is not blank, divide contract costs by total project cost
Seems easy enough but it is giving me errors.
IF(AND([Column2]@row = "yes", [Column3]@row <> ""), ([Column4]@row / [Column5]@row), "check later")
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.