Mike Wilday’s Profile

Community member since February 2017

Los Angeles Pacific University
IT & Operations
About Me
Skilled with SmartSheets reporting, formulas, cell-linking, sheet setup, etc. Email: [email protected]


I am trying to build a report that in the What? section has to contain a certain project number from the project number column but any then I want to be able to find 3 different resource from the project that are checked.  The big project is a Phase, then we have sections of the phase that contain


I'm new to smartsheet and going through (a lot of) various tutorials on YouTube. I picked from the Save Time And Increase Efficiency -which I'm obviously not good at- a formula that updates the STATUS column (green, yellow, red dots) according to closeness to the DUE DATE column, which is:



Is it possible to block different columns for different people?

There is Person A and B and there are columns 1-2-3-4-5-6,

Person A can edit info on columns 1-2-3 but has columns 4-5-6 lock

Person B can edit columns 4-5-6 but has column 1-2-3 lock

 If not, what can be a solution for it?


I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another



I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula

I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status


Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. 

For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically