-
Concatenate USABLE contacts
Hi all, I have created an FAQs board for my team to share knowledge. They ask a question through a Form, I respond and the requestor gets a direct email with the response. It also stores all the FAQs on a Dashboard for overall team review. I am looking to send the response not only to the requestor, but the overall team…
-
COUNT IF, INDEX, MATCH
I have one table with a reference number, a sub-vessel number and a check box column to select the desired subvessel. I want to use a formula in another sheet to count the number of times a value is present in SOURCE(subvessel selection column), where the SOURCE(reference number) matches the TARGET(reference number) and if…
-
How to count the number of multi-select selections that contain a string?
Hi there, I'm trying to devise a formula that counts the number of multi-select selections in a cell that contain a certain string. The closest I've come is: =COUNTM(COLLECT([Multi-select]@row, [Multi-select]@row, CONTAINS("STRING", @cell))) However, this confirms the string is present in any of the selections and then…
-
Using forms with Card views
We use Smartsheet to order sheetmetal ductwork for our HVAC jobs, and i'm trying to set up a form, linked to a card view, that will show wheta has been ordered and when it will be manufactured. The form entry saves by defualt in the first lane on the card view, i was wondering if its possible to make this form save in a…
-
Cross sheet countifs, multipul drop down in cell - multipul errors.
Hi All. I run the current cross sheet formula which is working when there is only One request type seleced in the cell. ie; Costing. When there is Two in the cell ie, Costing Drawing the results is not counted. I have tried changing COUNTIFS with COUNTM however this results in a count of 177, rep in question only has 13…
-
IFERROR and value in same formula
Hi, Hope I can clearly explain what I am doing. I would like a cell to show a blank if there is an error, but if no error, I want the value in the cell it is pointing to to put the same number in the formula cell. Example: if there is #DIVIDE BY ZERO - then leave blank; if there is a value, then put that same value in the…
-
Workflow Automation for a 2-week notice email
Hello All. I have a sheet that has staff name and their term date. I want Smartsheet to look at this sheet daily and send an email to HRC with details of staff whose term date is 14 days from now. to do that I originally configured trigger to two weeks before notification date and set my other two conditions but then…
-
A formula that can read multiple cells and return a value
I would like to know if there is a formula that can reference a column and identify if a cell contains specific text once the cells with specific text have been identified, read if the next column contains a date if both values are true then return a green dot and if the column 1 contains the text and column 2 does not…
-
How to set up an email reminder 7 days after creation date
Greetings, I'm trying to set up an automation to send an email 7 days after creation date but I'm having problems. I tried using the function =IF([Creation Date]@row) > TODAY(+7), 1, 0) but it isn't working as expected. When I change the date with a test date from a date column, it works fine. Any ideas what I am doing…
-
index match with a set of data (2 dimensional match)
I am trying to use index match but my match is using a range of data (not just 1 column, but many). This causes the match function to return a 2d number relative to the row/column matched and not just a row number. It seems index is expecting just a row number (and optional 3rd parameter for column) and this does not work…