one cell fill another cell

JenaW

JenaW ✭✭✭

10/31/23 edited 10/31/23 in Formulas and Functions

how can we make one cell fill another cell?

If I put a date in a column, I would like that same date to populate further right in the end date but for the next year

0 ·

Answers

Purnima Gore_PGPS ✭✭✭✭✭

10/31/23 edited 10/31/23

Hi @JenW
=Cell@row+365 in the second cell
As long as both are date cells that would work

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…
Can't get the "Ongoing" piece to work
I'm trying to make a formula, a typical status formula which I do often. But it was asked to include an "Ongoing" status when the % Complete column is at 99%, regardless of other conditions. The problem I'm running into is that no matter how I input it, the "In Progress" piece always overrides it, and I can't quite get the…
COUNTM Formula Help
Is there a way to use the COUNTM formula to count the number of selected dropdown options in a multi-select column (e.g., "Deposit Accounts") only when another column (e.g., "Region") equals a specific value (e.g., "East")? For example, I want to count how many Deposit Accounts have been selected only for rows where the…