Anupriya✭✭✭✭

You could also look at automated requests for the duration of the event. Automatically Request Updates on Tasks | Smartsheet Learning Center For the first time, the entry can be submitted using the form. For all the subsequent days of the event, you can have an automated update request sent to a user.

That's normal. A workflow is triggered only when the data in the sheet is saved.

You can refer to this discussion - Count Multi Select dropdown values — Smartsheet Community

You can try something on these lines - =iF(Status@row = "Closed", "", IF([Revised Due Date]@row<>"", IF([Revised Due Date]@row < TODAY(), "Red", IF([Revised Due Date]@row <= TODAY(7), "Yellow", IF([Revised Due Date]@row >= TODAY(8), "Green"))), IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row <= TODAY(7), "Yellow",…

Can you share a screenshot of the workflow? Also, you can add a condition to check for blanks. If the date is blank, do not send out the notification.

You can use the Smartsheet automation - Record a Date. In this automation, you can define the cell which triggers this automation to record the date when the change was made. Set the Current Date with Record a Date Action | Smartsheet Learning Center

The only reason that I can think of is a wrong date format. Other than that it should work fine.

You need to update the Gantt project settings. The display label looks to be selected as Assigned to column. Modify Project Settings | Smartsheet Learning Center

& doesn't work for concatenation in Smartsheet. Use + instead. Also, Smartsheet doesn't have a LOOKUP function. You can try VLOOKUP instead or INDEX-MATCH. Functions List | Smartsheet Learning Center

It might be an issue of selecting the correct range in the source sheet. When you start writing the COUNTIF function and click on "Reference Another sheet" to pick the right column, make sure you click on the column name. This will select the whole column. This should help with the issue.