Hello, I am trying to create a formula in Smartsheet that replaces a formula we are using in Excel that turns a cell red or green if the date entered is before or after a referencing cell date. If that makes sense. So – If the Review SOW date cell in a column is in the past and the Review SOW Complete cell is blank, that…
I am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024. =COUNTIFS({Electrical Status}, CONTAINS([Primary Column]@row, @cell), {Bid Date}, YEAR(@cell) = 2024) this is what i have (primary column is referencing the word bidding). I am pretty sure it has something to do with the…
This discussion has been merged.
I just went through an update where I needed to manually add 3 new sheet references to 26 Stakeholder Registers (78 total). I wish that after you click Insert Reference, the Sheet Reference Manager dialog box would remain open.
Please Remove Cross-Sheet Reference Limit.
Hi all, I'm making a sheet that references another sheet to get data for a detailed graph. I'm trying to count the total number of small, medium, and large projects. The formula I have that works for individual campuses is as follows: =COUNTIFS({Size}, CONTAINS("Small", @cell), {Campus}, CONTAINS("Example", @cell), {In…
Here is my Smartsheet frustration of the day. Yet another capricious limit: Why do these limits exist? Can there just be a confirmation box rather than a barrier? Thank you.
"Formulas are referencing too many cells on the source or destination sheet. To run this workflow, please reduce the amount of cells referenced by formulas." How do I figure out how many and what formulas are connected to the sheet causing this error? Neither the source nor destination sheets have the blue or black ▸in any…