-
Beware behind the scenes Date Format
Background: A colleague of mine ran into a problem with Dashboards being fed from a Summary sheet which was pulling data from Main sheets via X-Sheet References. The Dashboards were showing incorrect values until the Summary sheet was refreshed (opened) Investigation reveals (I believe) that the issue is due to how…
-
Smartsheet formula syntax help
I am trying to write a formula to add 9 months to date from another cell in my worksheet and am struggling with the formula syntax. Adding days to a date is very straightforward, but I have not been able to figure out how to identify how to add months to a date. Can anyone help with this formula? Thanks, John
-
Symbols not changing based on the value in another cell
Hi. I have applied a formula where RYG "status" column is counting days to deadline and changes colors according to how many days are left till deadline (=IF(Done3 <> 3; IF(TODAY() - Due4 > -7; "Red"; IF(TODAY() - Due4 > -14; "Yellow"; IF(TODAY() - Due4 < 6; "Green")))) Now i want to add another formula to column(Drop…
-
Tracking boxes checked per user per day?
Is there any formula I could use that would track the number of boxes checked by individual users for a specific day? I know I can generate this data in a report, but I'd like to create a formula so I could build around it.
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
-
Either / Or but not both
Hi Could someone help please? I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column. For example: Column A: Yes Column B: Yes Total: 1…
-
Conditional Formatting
Is there a way to add a conditional format to a cell that has a drop down RYG...like project health? If a task date is past due, I want the health cell to change from green to yellow automatically. Thanks for any help!
-
Counting "At Risk" Flags
Hi, I am trying to use COUNTIF for counting number of projects with "At Risk" flags turned on. I get #UNPARSEABLE for this- COUNTIF(At Risk:At Risk, 1). Any feedback appreciated. Thank you.
-
Formula Predecessor Help 2...
I could use some help. I've implemented J. Craig Williams' predecessor solution allowing notifications based on the predecessor being complete for a given task: 1. Create a column to get your Row# [RowID] In the first row, put a 1. The second row, use the formula =RowID1 +1 and copy that to all the other rows. 2. Create a…
-
Days Since (Single Date)
I have to do some invoicing and want to know how many days since an invoice was issued. I can sort out how to find the days between two dates but I only have one date to work with here. Would love if someone could help!
