-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thank…
-
Generating dates based on dropdown choice in another cell
Hi everyone, I'm very new to this and trying to generate a formula that will calculate deadline dates based on dropdown choices in another cell. If we get customer queries by phone, we have a deadline of 2 days' resolution; if we get them by email, it's 10 days. I would like to be able to auto-generate deadline dates for…
-
Automations Not Being Replicated Correctly By Control Center
For my project - I want Control Center to recreate sheets that have certain automations linked to it. These automations copy/move rows to sheets in the newly created project folders. However, when a new project folder is provisioned using Control Center, the workflow still writes the copied row to the original sheet in the…
-
Verify/View Automated Email Notification
Is there a way to view a log of the automated emails that have gone out? Some clients are receiving them and some are not so we want to have a system-generated log of what went out. Does this exist? The Activity log does not show this.
-
How to automatically copy a cell value to the next column
Hi =), It is likely a very easy solution for you guys. I've two columns one for the client names (Dropdown list) and another one for OTHER ( if they can't find the client name from the dropdown). I wanted to bring the OTHER client name automatically to the client name once someone enters data in the OTHER column. Goal is…
-
Automate sending a form
I would like to send out a form to a list of people on a specific schedule (weekly), so that they fill it in, and I collect the responses and report on the information. Can I use the Automation feature for this, or is this something that can be configured in the Form? How do I set up the automation feature to send the form…
-
Automation from Cell Value
I'm trying to create an Automation that sends an email when a cell in column is above a certain value. I would preferably like to reference the value of another cell in the same row in the email. I only seem to be able to create the Automation when the cell is exactly a certain value not above a certain value. As an…
-
How to connect symbols with text
Hi, I'm trying to connect the symbols to a column for "not started", "In progress", "Complete". Is there any way I can do it? I'm trying to change the text automatically when an assigned person change the status of the project. Please see the attached screenshot.
-
Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linking…
-
Today function issue
Hello Everyone, I want to address one issue that I am facing for a long time. I am using today's function in my sheet to check today's date for like birthdays or anniversaries and set the automation for 10 AM (Time zone in India (GMT+5:30). For Example - Assume on 23t December it was my birthday so at 10 AM I should…
