-
Automotion with condition containing wildcards
I'm looking for automation changing a value in a given cell based on the email provided in another one. Literally, if the email provided in Cell_1 bellongs to the domain "@domainAAA.com", Cell_2 should change to AAA. If the email belongs to the domain "*@domainBBB.com then Cell_2 should change to BBB. I am wondering how I…
-
Filling names in on a form
I'm working on a cell phone porting project. I created a sheet that has each employees name, department, device, and phone number. I also created a form to send to the managers of each department. I want the manager to be able to see the names of employees and then select if they are "keeping and porting" or "returning"…
-
Survey response limits
We have created a survey to send to employees to rate our IT department. We want it to be anonymous but we also want to limit to one response per employee. I don't see anywhere to set that limit of one response.
-
Help with formula
Can anyone help with the below formula? =IF(OR(Status330 = "Complete", 1, 0)(Status330 = "Not Required", 1, 0)) It keeps returning UNPARSEABLE.
-
Alert a form user
I am wanting to alert a form user when their request is complete. So the user submits a form for their requested service. We have a status column in the grid. When the status is changed to complete, I would like the user who submitted the form to receive an alert. Is this possible? Thank you!
-
Can you append sheets in Smartsheet like you can power query in excel/power bi
Hi I want to append/consolidate sheets in smartsheet in a master file or separate sheet all the sheets are the same but for different locations im using forms to collate the info because the forms are site specific I want to combine the two sheets below as example in a master sheet and at the same time the master will…
-
How does the Alert someone when rows are added or changed works?
I have a automation, which says trigger: when rows are added, when column 1 changes to Marketing and it alerts specific person from the team. This works fine. However, I see the person who submitted the request has choose wrong department and if I manually try to change the Column 1 value to lets says Digital (after the…
-
Frozen Column on report within Dashboard
I have frozen the primary column in the sheet, I also created a report and froze the primary column in there as well. Once I apply a widget of the report to my dashboard the primary column is not frozen. Is there a work around or a solution to this issue?
-
Link cell automation
This is probably a "no," but I am working on transferring a lot of Smartsheet data from one sheet to a new format, and it is requiring a lot of manual labor, so I'm trying to automate as much as I can. One thing I am doing requires me to link the cells in certain columns to another sheet. Is it possible to set up an…
-
Nested IF Statement
Can someone help me fix this formula: =IF([Provider_Helper]@row = "Provider", JOIN(UPPER([FName_Helper]@row + " " + [Last Name]@row) + ", " + Credential@row), ([Provider_Helper]@row = "Resident", JOIN(UPPER([FName_Helper]@row + " " + [Last Name]@row) + ", " + Credential@row) + " (" + Role@row) + ")", (JOIN(UPPER([First…