-
Reference Codes
Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out, is there a way to make this a rolling serial number as each update request is…
-
Automated Message Response to Form Completion
I have a form that has a fair amount of branching in it with multiple columns and I have my automation setup to email for approval when a new line is created. My problem is with all the branching the form that is emailed has a lot of blank sections. Is there a way to only include the columns with data? I see the automation…
-
Formula for symbols
Hello team, I have created a Health column that is dependent on the project status column. Chose properties to be symbols red, yellow, green, blue. I have created the formula below but the results returned are spelling out the colour name when I want the symbol. What am I doing wrong? 😔
-
If Function
I've tried everything. I'm sure it's a simple fix. If Type = New, then Store Open Date needs to be OPS T/O + 4 days If Type= Remodel, then Store Open Date needs to be OPS T/O + 2 days. HELP! Please. Thank you. =IF((Type@row="New"), ([OPS T/O]@row+4), (Type@row="Remodel")([OPS T/O]@row+2))
-
How to split a multiselection dropdwn Column to various single columns
Hi, I am sending a form for customers, and they have to select the regions when they want to have a service. Once I received their selections, I need to split the multiselections dropdown column to different column containing the different regions selected but individually to be able to send specific notifications for…
-
Cross Sheet Formula to list children in separate cells
Im creating an agenda sheet template where people can plug in a parent SKU, and then if there is children it auto populates all the children SKU underneath it, each child in its own cell/row. I can get it working manually adjusting formulas, but was hoping to get a more user friendly version that people can drag the…
-
Formula Index/Match -has any of
Hi is there a way to create a formula that will match to 'has any of' instead of an exact Match? Here is my current formula: =INDEX({Look Up Table Range 1}, MATCH([Sold To Name]@row, {Look Up Table Range 2}, 0)) If my look up table has the name "TEST 12345" I would like my formula to still pick up "TEST" and populate -so…
-
Info in email alert not same as on smartsheet
Good morning, I created a Smartsheet for employee anniversaries. The formulas and automations are all working perfectly, there's just one strange thing that is happening. In my Smartsheet, I have a formula to calculate the anniversary number which works great, however, the anniversary number doesn't always translate to the…
-
If function
Hello, I'm happing trouble getting an if function correct as it keeps returning #unparseable. I have a nested if function in a contact type column. Depending on the value in the Service column of a row, it would return a specific email address. I have pasted the formula below although I've changed the email addresses for…
-
Net duration between 2 dates AND hours
Hi, I use this formula to calculate duration in minutes between two dates and time (see picture attached). Goal is to time delay of response between reception of email and answering email but to exclude hours people are not working. Here is the formula to Start time : =IF(SUM(VALUE(LEFT(RIGHT([Date et heure du courriel du…