I am tracking some weekly data and would like to know if it's possible to update the date within the formula quicker that manually entering the date?
Is there something similar to the drag and fill that I can do?
Yes, you can write Date formulas that will update based on criteria you specify in the formula.
If you provide a specific example of what you are trying to do, I can help you with the formula.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.