I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
Hi there,
This is pretty simple. After you have linked the cell... you can use simple math to adjust the days. For instance. If you have a linked cell in [Column2] row 3 and want to add 10 days to it. In a new column (set up as a date column) and row, use the following formula. Do note that because you are creating a new date you need to use the Date Column type to make that happen.
=[Column2]3 + 10
If you want it to be 10 days before that date use this formula
=[Column2]3 - 10
If you want it to be 10 working days after the linked cell date and you have set up your working days in your account settings.
=Workday([Column2]3,10)
Or 10 days before.
=Workday([Column2]3,-10)
Hope that helps!
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…