Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi,
I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days.
Thanks!
Keren
Hi Keren,
Try something like this.
=[Date of Deposit]@row + 84
The same version but with the below changes for your and others convenience.
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
The above solution is the simplest method.
Would that work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi Andrée,
Thank you so much for your reply! Unfortunately, it didn't work for me and just turned the year into 1984. Is there anything else you think might work?
I'm new to this so I appreciate your help!
Happy to help!
What date do you have in the date cell? Is the column formatted as a date type column?
The Date format for the Date of Deposit is 06/10/19. Each row has a different date. I would like the Estimated Completion Date column to have the same format. Both columns are formatted to Date - they currently are checked off as restrict to date format only. Should that change?
That's strange!
Can you paste the formula?
Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
Attached is a screenshot of what it looks like...let me know if this helps?
Thanks again!!!
Can you share the formula you're using as well? If you click on one of the dates in the Date of Deposit column is the date picker at that date when you open it?
The last formula I tried was the one you sent....not sure what you mean by date picker - would you mind elaborating?
Thanks!!!
It seems like your columns aren't formatted as date type columns.
Can you double-check?
Thanks so much - you were right that one of the columns wasn't formatted correctly. Which formula do you now suggest I use given the sent snapshot of the columns?
Try the one I sent before.
Did it work?
It worked! Thank you so much for your help and patience!
Excellent!
Hi all, I am trying to build out a formula that will return "True" if the CIF #@row can be found above it in the same column (CIF #) AND the Days Since Created is between 30 - 365 days. All of the formulas I have tried have only gotten me so far as the "AND". Adding in the dates screws it up. The goal is to determine if…
I am getting a lot of REF errors for my predecessors and I can't figure out why. At first I thought I might have REF for predecessors to predecessors but that's not the case. When I export the file into Excel it shows the IDs in the place where it shows REF in SS. Each time I refresh the file I feel like different values…
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
