Formulas and Functions
Archives for July 2018
Discussion List
-
Stale time/dateIn Formulas and FunctionsHi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notifica…
-
Manual Copy and Paste of rows fails to paste formulas and hierarchyIn Formulas and FunctionsAbout 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to copy rows from one sheet manually using C…
-
index match formula not workingIn Formulas and FunctionsHi, I am using the below index match formula which is not working. The MFG Rev 18 area range is a "contact list" column type, and the column used for the formula is a Text type. I assume the formula is not working due to the ty…
-
Need Help With "VLOOKUP"In Formulas and FunctionsI would like some help trying to figure out a "VLOOKUP" formula. I am trying to get the circled number on the attached file to go onto another sheet. I have tried all different ways and I cannot seem to get it to work. Please hel…
-
Write Function that has 2 check boxes in it?In Formulas and FunctionsHi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be. I have columns for Qu…
-
Average of durationIn Formulas and FunctionsHi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it doesn't seem to recognize them as numb…
-
Sending Multiple lines for Approval at one timeIn Formulas and FunctionsHi, has anyone figured out a way to send an approval request for more than one row at a time? I have rows that all need approved that need to be sent in the approval request along with their information, much like a daily notification of …
-
Multiple IF / AND / OR Statements Help, Please.In Formulas and FunctionsThis is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head. I have a [Target Date] column, [% Complete] column, and status column that …
-
Project Team Resource AllocationIn Formulas and FunctionsHi, Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this information for executive reporting …
-
Multiple IF StatementsIn Formulas and FunctionsCan we do multiple IF statements? I've tried to use IF and also OR to complete the function I'm trying to do and nothing seems to work. I want my Status column, "Not Started", "In Progress", and "Completed" to…