-
How do I modify a 24-hour helper formula to include non-numerical values?
I have a column with AM/PM times set up as a single select drop-down list. In order to make this column sortable, I created a helper column that converts the AM/PM times to 24 hour times. The formula in the helper column is as follows: =VALUE(IF(VALUE(LEFT([Requested upload time]@row, FIND(":", [Requested upload time]@row)β¦
-
IF Formula help
Hello, I am looking to add a conditional if formula but not sure how to move forward and unsure if smartsheet has a capability. Is it possible to check a column based on 3 other columns if not blank. and if so what do I have to write for the condition of columns not being blank. I got as far as selecting rows but unsureβ¦
-
Automation - Change Linked Sheet
Hi All Is it possible to change the linked sheet in the email that is received through the automation workflow? Here is my challenge // Automation - IF Status Change from GREEN to RED THEN notify individual and COPY ROW(s) to task sheet Notification Email - Hi [Name] the following items have changed status, please reviewβ¦
-
Duplicate Value Column not updating
Hi, I have written a formula for detecting duplicate values in the primary column of my sheet. The result is stored in a second column. Here is an abstract version of that form: IF(COUNTIF([Column 1]@row:[Column 1]@row, [Column 1]@row) '>' 1, "YES", "NO")) What this formula means is that if there is more than 1 occurrenceβ¦
-
Receipts for past notifications/updates
Hey folks - is there a way I can view past notifications that have been sent through Smartsheet system? When I go into page history I cannot see any record of past automation/notifications sent through the sheet. Thanks!
-
Help w/ Status Formula
Hello, I have the below status formula created but when I do not have a start/end date populated, the status is populating as "complete". I want it to be blank until all 4 dates are entered. Any suggestions? Formula: =IF([Baseline Start Date]@row <> "", IF(AND([Start Date]@row <= TODAY(), [End Date]@row > TODAY()), "Inβ¦
-
Duplicate formula
I am currently using this formula to identify duplicates, =IF(COUNTIF([Invoice Number]885:[Invoice Number]1735, [Invoice Number]885) > 1, 1) New lines are now doing this, =IF(COUNTIF([Invoice Number]1002:#REF, [Invoice Number]1002) > 1, 1) because the formula is looking for lines greater than the sheet currently,β¦
-
Automatically Change Value in Drop-Down Box
I might be overthinking this, but I have a drop-down box (called PD/C Approval Status that is used for automated request for approval) that includes the following values: Requested Approved Not Approved No Response ---- The default is "---" until the approval workflow is initiated, which then changes is to "Requested" (viaβ¦
-
Vlookup formula help
Hi, I am doing a VLOOKUP in which the formula looks up a list of holiday dates listed in a range from a second sheet. If matching, it is to display the second column which identifies the type of holiday (note, in the formula below I have "false" I also tried "true"). The columns sources are both type: date. the formula:β¦
-
Simplify Formula
I have a formula that checks to see if a date falls between dates. If so, it marks the row current or previous. The goal is to see if the date falls in the current year or the previous year and then label the row accordingly. The formula references another sheet where the dates are calculated. It has a column for the startβ¦