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 share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users.


Before we signed up to the paid account this was an option.






Hi there!

I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. 

The issue I'm having is that the



I am trying to create an IF(AND) statement, but I cannot figure it out.  Any help would be greatly appreciated.

I am trying to write a formula that will check the "at risk" if the the "done" column is not checked and the due date is 7 days before today.


Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I