-
Retrieve Date from Data
Good morning gurus! I have a tricky one today. I need help retrieving data from a cell. The column (Routine Execution) contains information imported from another program and looks like this: 5S Audit - Jul 29, 2022, 04:01 PM Gemba Checklist - July 13, 2022 I was able to pull the date from the above data using the following…
-
Taxonomy Validation
Hello! I want to start off by saying I am a novice with Smartsheet but am hoping you all can help me. I have a sheet that will contain a taxonomy value. I want to build some formulas in Smartsheet that I have built previously in Excel and I can't seem to figure it out. There are two things i am looking to validate, 1 that…
-
Inserting/Creating a Row Automatically
Is there any way to automatically create/insert a row into a sheet based on a trigger from within that sheet? Essentially, copy a row of a sheet and paste it as a new row into the sheet with a different status or different value in a few columns?
-
When Pre-populating a form, how to deal with a column with multiple choices?
I just got it to work except for 1 thing. Here is the formula: ="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=" + Date@row + "&Team=" + Team@row + "&Issue=" + SUBSTITUTE(Issue@row, " ", "%20") + "&Notes=" + SUBSTITUTE(Notes@row, " ", "%20") One of the columns is a a dropdown with multiple…
-
Is it possible to calulate average of a time metric?
Hello, I have a column for Avg Handle Time, where each row is formatted as: 0:00:00 How can calculuate the average of multiple rows? I know with Excel, you can just highlight the whole column, and it'll calculate the average automatically. How would this be done in Smartsheet? Thanks in advance, -Cyrus
-
Nested IF AND statements
I am trying to add logic to a nested IF statement that would allow me to ask a question in a form. I am using the following nested if statement without issue. =IF(WEEKDAY([Date Created]@row) = 7, [Date Created]@row - 1, IF(WEEKDAY([Date Created]@row) = 1, [Date Created]@row - 2, IF(WEEKDAY([Date Created]@row) = 2, [Date…
-
Filter on row status that IS NOT a summary field
This may seem pretty novice... but I am having trouble adding a summary sheet filter that IS NOT a summary item... For Instance, if my sheet is Column 1: Assigned To (ex: Joe, Jennifer, James) Column 2: Functional Area (ex: Benefits, Staffing, Recruiting) Column 3: Status (ex: Passed, In Progress, Failed) I built a sheet…
-
SUMIF not working with text strings pulled in via Index/Match
I am looking to calculate a running total value for the amount of financial assistance we provide for some of the moms that we help at our organization. I am currently pulling information over from our "Mom Master List" to another sheet via Index/Match, and then adding additional information in other columns. When I try to…
-
IF formula correction please
Hi There, It is a Monday morning for me and a distinct lack of coffee means that the above formula is likely an absolute shemozzle. Essentially I am trying to return an argument that says If the Priority rating shows this (eg H5) then return this number (eg 15) in the helper column. This formula (once correct!) then also…
-
Check the flag
How can I get the flag column to activate when the date in another column is over 30 days old? I have been trying to do this in "conditioning" but can't get it to work. Thank you