-
Identify Duplicate Values, only within the last 7 days, based on unique identifier (code)
I want to identify when a code is a duplicate in the last 7 days but I'm struggling with the logic/syntax. Essentially people call in for assistance and we track that. When we put a closed date in, automation automatically sends a survey. However, if they call in more than once in a week, I don't want to send them a survey…
-
Automation send alert to secondary email
Hello, When setting an automation to send an alert about new fields added to a spreadsheet, the alert arrives to primary email address even though it was set to be sent to the user's secondary address. How can I ensure the alerts arrive into the user's secondary email address only and not appear in their primary address?…
-
Automation in Workflows
How can I Request an update to separate person as per the specific data in the form. For example, we have 4 department named Dept 1, Dept 2, Dept 3, Dept 4 and we have 4 separate managers for each department M1, M2, M3, M4 respectively. Now, when the form is filled up and in the department section, Dept 1 is selected, than…
-
Column Name
Hello, I'm creating a dashboard from data in excel that is extracted from other systems. I want the input grid in Smartsheet to be exactly the same as the excel i retrieved. The first row has the date headers, and I want these to be the column names, so that i can create the graph directly from the input grid. Is there a…
-
Column formula do not appear in form
Hello, Hope you all are good in this crazy time. I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible: I want to create a form with some fields "auto-fillable" based on a cross-reference VLOOKUP formula. I have a main sheet and there is a column…
-
Setting a status based on date fields
Is there a way that I can update or set a status based on data in 3 other fields? What I am trying to do is set a status based on data being entered in 3 other fields - if those fields are blank, then status would be 'In Progress' if those fields contain data (dates or text) status is 'Complete'? Is this doable?
-
Matching data across multiple cells
Hi all, I feel like this should be pretty easy but I can't seem to work out how to get this done... I have a sheet with 3 columns that capture different locations - what I am trying to do is return a status/value if all 3 of those locations match, a different value if none match, and again a different value if only 2…
-
Formula help
Quarter 2 (April- June) I need the formula that does the following: Take the week of 5-Apr + 12-Apr +Apr-19 and that would populate for the [actual number], the remaining weeks would be [planned]. Than dynamically the formula would auto populate each week consecutively so that it would add the current week to the sum of…
-
Can I Disable Rollup Percentage
Hi, I'm working in a Master SS that all departments are contributing information into. My particular project is being run in a separate SS and I'm only pulling 5-6 line relevant line items in and linking them to the Master SS. Those 5-6 line items are the children in the Master SS under the department's name and they do…
-
Is there a formula to calculate loan payments?
I need to calculate the periodic payment of a amortizing loan with level payments and a constant rate of interest. Is there a formula that I can use in Smartsheet to make this calculation?