Trending in Formulas and Functions
-
Sum IF Help With a Formula - I think it is SumIF
Hello all, I have a sheet with a column that has this formula in a column labeled "This Month Available Hrs Remaining" =NETWORKDAYS(TODAY(), IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, DATE(YEAR(TODAY()) + 1, MONTH(TODAY()) - 11, 1) - 1)) * 8 * Count@row This formula lets me know how many man hours I have…
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…