-
URL Query Strings & Contacts
Hi I am using a query string with a form URL to prepopulate a form with row information, which is passed to another sheet. All works but I am have challenges with passing contact info. The source form has a column property of "Contact List", and the target form has a similarly formatted column. However, despite various…
-
Cannot calculate future date based on two source fields.
When adding a set of days to a historical date usually that will give you a future date example: =[Sale date]@row + [Delivery days]@row will give me a future date When using Data mesh or Vlookup to bring the two source fields to another reference smartsheet, the delivery days will add to the year instead of the days, thus…
-
How to add WORKDAY function into a date cell using an IF statement
I'm trying to fill in a date column that if another column is "Y-TK SEND", then the date cell should add 5 business days from another date column. I am able to get it to work if I don't use the WORKDAY function but I need this to be 5 business days and I have no idea where to put the WORKDAY. Please see the formula I have…
-
Linked Cells not updating in report
I have created a dashboard to see the daily job status. One of the functions is to see how many jobs are open on Today's task list. This is based on countifs on the date of the task list. The formula's are sometimes working, sometimes not. When we make an update on the tasklist, the report does not show the latest updated…
-
Document generations
We are using Smartsheet forms as most people are to systematically gather data from multiple team members. I have automations notifying team members of updates and new records coming in. I recently set up some mappings from a Smartsheet to a pdf with fields to automate the output of pdf forms. I need a way to automatically…
-
Can one cell be divided unto another cell
Can the value in the Inpatient YES box be divided by the value in the Inpatient box? It would be 2/3. If so, what formula should I use? Picture is attached.
-
Formulas in reports don't work
Hello, I have formulas working properly in the sheets, but not in the report. For example, when a task is "Complete" in a sheet, the done checkbox is ticked and the dot gets grey; when I do the same in the report, only the status is updated. Similarly, in the sheets a formula makes the dot yellow 15 days before the end…
-
Formula to Produce Symbol based on other Symbols
I have a very complex formula I need help with... using dates and symbols in other columns to dictate the symbol produced. The 'LIVE' column below will populate with green, yellow, red, or grey based on a combination of the following specifications: 1) If Target Go-Live date is passed AND Kick-Off is green, AND MSA is…
-
How to transfer data from one sheet to another and then have it place in the correct place
I am trying to take data that is input in a form and managed in one sheet and automatically copy it to another sheet linked and input in a certain section based location criteria. Here is currently what I am doing: Form Sheet form data goes into that I want to use to manage a dashboard Sheet that I want to automatically…
-
Formula don't work in reports
Hello, I have formulas working properly in the sheets, but not in the report. For example, when a task is "Complete" in a sheet, the done checkbox is ticked and the dot gets grey; when I do the same in the report, only the status is updated. Similarly, in the sheets a formula makes the dot yellow 15 days before the end…
