-
Delayed automatic form entry response
We wanted to create automatic delayed response to a form entry. It would send email back to whatever email was entered into form field 72 hours after the form has been filled. The response would say something like: "Your request has been approved". We wanted auto data stamp column to generate that response but automation…
-
How do I return a date based on a dropdown value?
Hi all, I am trying to work out a formula to get a cell to return a date based on a dropdown value. I need the cell to tell me when a matter is due, based on when the matter was received and the priority rating. the priority levels are (Service Type): * Fast track - 7 days * Basic - 14 days * Standard - 30 days * Complex -…
-
Auto-populating form fields
I'm working on a form right now and am having some issues that I'm hoping someone can help me with. I'm trying to develop a form that auto-populates specific fields. Something similar to the "request an update" feature, but in a form that I can edit the look and layout of. I've tried using a query string, but so far I…
-
CONTAINS, MATCH, INDEX Help
I'm trying to use CONTAINS, MATCH, and INDEX in cross-sheet formulas to pull location-specific system component inspection information from invoices to my asset register. Sometimes, the invoices will have more than one system component on them. I want to make sure the formulas will pull the information for each of the…
-
Automated Workflow vs Reminders
I want to be able to have emails automatically be sent out 30 days prior to xx date for a sheet. I've been playing with the workflows and can get it to work but it needs a trigger. Whereas the "set reminder" can do what I want without a trigger but only goes out 14 days. Is there a way to get email notices based only on a…
-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
Gantt View - Limit Columns Shown
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row very tall in Gantt view, and makes the schedule difficult to read. Hiding these column doesn't help. Is there a way to…
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
-
#INVALID OPERATION (SUMIF/SUMIFS to blame?)
The formula I'm trying to fix was not reporting our information correctly so I built a new formula in a test environment and it appeared to be working as intended only for me to find that when applying it in a live setting, the result was constant #INVALID OPERATION errors. The formula is this: =IF([Est. Annual Rent]@row =…
-
Copy of my responses
I'm not sure if this was already addressed in a previous post or not so I appreciate your patience. I created a registration form that has 6 choices for respondents to choose from. Is there a way to format the "copy of my response" email to only include the specific choice they picked? Currently, the email includes all 6…