Sign in to join the conversation:
Hi - I'm trying to add 6 months to the day to a date referenced in another field. It is basically a date of execution and plus 6 months a review date. How is this possible? Adding the number of days gets me close, but not exact.
Thanks!
Try something like the below. We first use a DATE function to simply add 6 to the month. Then we use an IFERROR function to produce a different date if the month + 6 is more than 12. The different date would simply be subtracting 6 months and then adding 1 to the year.
=IFERROR(DATE(YEAR([Execution Date]@row), MONTH([Execution Date]@row) + 6, DAY([Execution Date]@row)), DATE(YEAR([Execution Date]@row) + 1, MONTH([Execution Date]@row) - 6, DAY([Execution Date]@row)))
Hi Smartsheet experts! I'm trying to accomplish something like the above, where I count the number of repeats of one value in a column, but that count resets when the value changes and resets to 1 if the same name appears later. This is to consolidate an order form where users can order different numbers of items- it's…
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?…
I need help creating a formula to calculate how many hours my team is allocated for per week. I have three columns in my sheet that we use for task management. Hrs per week - is a number on the hours it takes Assigned to - is a manual text field of the team member who is doing the task Due Date - when it is due (typically…
