I'm linking a handful of cells to another spreadsheet, however I noticed the dates that are pulling through are incorrect. I've confirmed I'm pulling up the correct sheet/cells to link too but for som…
I have set-up a Dynamic View (DV) filter using a helper column that converts a date to a text field display (this was required because DV doesn't allow filtering from a date field). I'm asking it to d…
How long does it take for new column to become available in Dynamic View as an option to choose? It's a text field so I already know that is a value that is acceptable within Dynamic View. I created m…
Example: If cell A3 contains a date of 04/25/23, I'd like cell A10 to auto-populate a week-ending date of 04/28/23. All the dates in cell A3 will occur sometime Monday thru Friday. The day in cell A10…
I've added a couple new fields to a Smartsheet and am looking to filter against them within Dynamic Views. Within Dynamic Views settings I've added these fields to both the View Display "Visible Field…
On a Gantt chart, I've added a column % Progress Expected and I have it calculating % progress expected per day for each line item, based on the duration; see formula below. =(TODAY() - Start@row) * (…