-
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!
-
Harvey Balls / Lookup or Max ?
Dear all, I am trying to find a smart way to use formulas to make a large data table more accessible. The situation is as follows: I have a number of companies that are represented by one line in smartsheet. This line included a unique ID as well as names, etc. For each companies I can have 1 or more lines - children -…
-
Counting formula to see how many status each person has
So I want to see how many Not Started, In-Progress or Completed each person has.
