-
Picking next populated cell with formula
I'm trying to populate a cell (current email) using a formula with only one column being populated. Reading: Populate cell "Current email" with either "email 1" @ row or "email 2" @ row or "email 3" @ row... Thank you.
-
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…
-
How to Remove Apostrophes in Front of Numbers?
Hi all, My problem is SS has put in apostrophes in front of numbers after importing from excel. I have a column that is comprised of both text and numerical values. I've tried using a value function to remove the apostrophes. This works for the numerical values but shows errors on any cell containing text. Does anyone have…
-
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,…
-
Deducting months from date not returning correct year
Hi - Can anyone help please with deducting a number of months from a date and get it to return the correct year? I have a contract expiration date column and a notice period (in months) column. I've used the below formula, but where I have a date of 31/03/2022 (Contract Expiration Date) and a notice period of 3 (Contract…
-
Link to First Row With a Blank Value in a Specific Field
I have two sheets, and I wish to link to a value in one sheet from a cell in another. Specifically, I want to include the value in Milestone, 2 in the 1st screenshot, as it is the first value with a blank date in Baseline Completion Date. The value would be linked to 6, 3 (Stage) in the 2nd screenshot. I tried using an,…
-
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…
-
Pulling monthly numbers formula
I am trying to use a smartsheet to report the number of alerts received during an entire month. There are 9 types of alerts and I need to know how many we had for a specific month. The information is being pulled from another smartsheet log which has dates going back to 1/1/2020. The below metric and formula I created is…
-
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:…
-
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!