JCluff✭✭✭✭

I'd give my kid the $20 and tell them to find someone without a lunch each day at school, buy them lunch and share a meal together.

Hi @RayB , Gantt view will allow up to 2 dates per row, ie: Start & Finish date, and they wouldn't show as milestones but instead a colored bar. The actual Milestone markers need a 0 day duration. In order to do what you are wanting each SG would need it's own row. Is this portfolio sheet a summary sheet made in Control…

@YH_2022 You just need to add a ISBLANK() formula to the beginning of the formula. =IF(ISBLANK([End Date]@row), UNICHAR(9899), IF(Status@row = "Complete", "Blue", IF(AND(Status@row = "Not Started", TODAY(5) <= [End Date]@row), UNICHAR(9899), IF(AND(Status@row <> "Complete", TODAY() > [End Date]@row), "Red",…

@SIFF_Volunteers, Without seeing how your reference table is set-up I'm not sure if we can fully diagnose the VLOOKUP error. I would actually recommend that you start using INDEX(MATCH()) to avoid errors when columns/data are moved. The formula would look like: =INDEX({Code Column},MATCH(Email@row,{Recipient Column},0)) If…

@Gaurav Chauhan The parenthesis is missing for your AND() statement. Try: =IF(AND(Count3 = Sum3, Sum3 = Total3, Total3 = Product12), 1, 0)

@Austin Gillitzer I can't recreate the miscalculation, but try wrapping the [Creation Date]@row in a DATEONLY() like pictured below: =IFERROR(NETWORKDAYS(DATEONLY([Creation Date]@row), [Approval Date]@row), "")

@Jeff克莱恩,你是正确的,这不是currently available. To avoid asking the user to open the report & the form you can combine the two in a dashboard as an interim fix until dynamic fields and look ups are added to Smartsheet Forms (hopefully in the near future).

@Paul Newcome, thanks as always! Didn't realize the cross sheet reference would interfere with the trigger.

The report that the chart is looking at will need to be sorted from low to high.

Yes, Smartsheet is currently experiencing some issues. I'd recommend bookmarking the below link: https://status.smartsheet.com/