Mike Wilday’s Profile

Community member since February 2017

University College at Azusa Pacific University
IT & Operations
About Me
Skilled with SmartSheets reporting, formulas, cell-linking, sheet setup, etc.


I noticed that Smartsheet is further considering task duration it it's resource planning, even the task is already completed. I would have expected, as soon a task is completed, the duration of the task will not longer be considered in the resource management planning. 

Any recommendation or



I need to trigger a 'reminder' to customers when their appointment is 2 weeks out. So if today is June 1st, everyone that has an appointment on June 15th would get a reminder.

Can anyone help with a formula for that?  



I have two formula questions.


1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green",


hey crew. 

So I am trying to notify customers when somthing in a certain cell in their row changes.

So I created a column where I can put in email address of the customer. Then I made the alert that anytime that column changes that the customers email would be notifed. Well, I used my email as a