-
Expiry date based on number in column
Hi, I am trying calculate expiry date based on the value in 'valid for' (# of years) column. Here are the formula I am trying to work with: =IF([Valid for]1="2", [Training date] + 730, IF([Valid for]1="3", [Training date] + 1095, IF([Valid for]1="0", [Training date] + 7300)))) Thanks, AL
-
IF Formula
Hello, could you help me understand what is wrong with this IF Formula? I refer to the link below with the formula =IF([Order Date]3 < TODAY(), "Red", IF(AND([Order Date]3 >= TODAY(), [Order Date]3 < TODAY(+7)), "Yellow", "Green")) My formula =IF([% Complete]@row < 70%, ''RED'', IF(AND([% Complete]@row <= 70%, [%…
-
Determine the Finish Date using NETWORKDAYS
Hi all, We have a group of tasks that commence on a given date. [ISSUE DATE] We would like to automatically populate the adjacent cell with a date, which is +5 business days from the ISSUE DATE. I'm assuming we need to use the NETWORKDAYS formula but I can't determine how to achieve this. Thanks for your assistance.…
-
Pull month and year
Is there a way to pull the date and year from one column to another? I am currently using the following formula to pull the year out of the Report date column. Report Column. Mandated Date Column 10/8/2020 =IFERROR(YEAR([Validation Report IA Date]@row) + 1, "") I would like the "Mandated Date Column" to display the…
-
Flagging a cell based on checkmarks
Hello, I need a cell to flag if there is a check mark within a range of cells. I currently have a box checked if the schedule date matches a date in another column. The box checks if the Install Date matches the test date so I am thinking that if there are any check boxes within those columns I should raise the flag. At a…
-
Filling in an email address in a workflow in an automation workflow form
I have an automation workflow that requests an update through a simple form. One block on the form asks the receiver to complete the email of someone who should be notified (the question is tied to a Contact List column in the main sheet). In testing, when the user tries to type in the email address, the form locks up…
-
if formulas, and adding status symbol (Empty, Quarter, Half, Three Quarter, Full )
Good morning! I need some help with these Smartsheet Formulas. I don't even know if it is possible, but I am trying to get a formula written that captures the status of column "Complete Date". As people fill in the date they completed their task, it will translate the status symbol to the appropriate amount. I am just…
-
Search for assigned manager, then get list of direct reports
Hi - I am trying to create a formula in a Contact List column that returns all the people reporting to a manager. I do not know the best way to build this formula. Would someone kindly help me with the best way to do this, and possibly get me started with a formula? In the images below is my prototype. I have 5 employees…
-
Calculate column running total from ONLY last 12 months
I want my columns to be like this.. Column A (Month & Year) Column B ($ in) and Column 3 (Running total from last twelve months) Any help would be appreciated! Thanks🦓
-
Adding "If" statement to an INDEX and MATCH formula
Hello, I've created an INDEX and MATCH formula to update a daily staffing sheet. So, it shows the employee status for TODAY(), based on another sheet. I realized today that when there is no value (which is fine - that has a meaning), I get #NO MATCH. Is there a way I could do some sort of IF statement or something to let…
