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 if date is equal to or between dates
I want to create a formula to do the following: If the "Created Date" is equal to OR between the "Week Start" and "Week End" dates, I want to check the "Submitted on Time" box. I tried =IF([Created Date]@row, >=[Week Start]@row, <=[Week End]@row, 1, 0) and am getting an INCORRECTARGUMENT error. I'm sure I'm missing…
#Invaldi Operation when a date dell is blank
Trying to analyze multiple date columns against a current date to ensure the training has occurred within the last year and if not then flag as needing to be trained. But when I incorporate the various date cells for reference I get the #invalid operation error for the blanks. Formula: =IF(OR([DTMC & Trainer Training…
Is anyone out there having trouble getting new automation workflows to run?
I have a large project management sheet with lots of automation that we have set up for many columns. We currently have 60 automation workflows in the sheet and they are all working fine except for some new ones I added recently. Have I exceeded some kind of limit? I have added about 4 columns to our sheet that need to…