-
Help with Formular with two criteria adding to date value
Hello, I am assisting a team in moving from an excel sheet to Smartsheet. The formula they currently use to perform a calculated function isn't working and I am getting INVALID DATA TYPE as the error. I admit I am not the best formula writer. Basically if the new row meets he two criteria only then should the cell populate…
-
Sumifs with AND and OR Criteria
Hi, I'm trying to collect a "Total Amount" if the following criteria is met: The "Category" is "Banking" The "Owner" is "Resident" The "Account Type" is "Checking" or "Savings" I figured out how to do Criteria 1 and 2. It's Criteria 3 that is getting me stuck. I know I can combine a few different Sumifs formulas together,…
-
IF(ISBLANK formula for multiple columns
Hi I want a formula to show which team has been selected across multiple columns: So if Construction has been chosen, in one of the columns, this will show in the Team column. Only one team will ever be selected per row. The formula I have is shown above but it's returning a #impasserable I'm assuming I've got too many…
-
How do you automate a status updates in smartsheet with IF formula?
My organization would like to automate the statuses in a project plan. Could we create an IF formula to accommodate this logic? Examples: If the start date is in the past and the percentage is 0%, put status in yellow If the percentage is 100%, put the status in green If the end date is past due, put the status in Red
-
Best method to return a list based on a multi-select column
I hope I'm close with this solution, but I just can't make the formula work. I have a list of therapists who are licensed in multiple states. Sheet with formula: A list of patients needing a therapist. Their state is indicated in a "State" field. Second sheet: A two-column range of "Therapist last name", and "States…
-
How to Average(Collect()) while ignoring error messages
I would like to average the entire Value column whenever Customer is 'Y'. I've been able to successfully do if there are no formula errors by using the following: =AVG(COLLECT(Value:Value, Customer:Customer, true)) However, I discovered if there is an error in a value cell, the formula fails (it throws #NO MATCH error…
-
Help with returning Yes value if multiple criteria is met
I am trying to identify which RED customers from one Sheet 1 have already been added to our CEM (Customer Escalation Master) Sheet 2, so I don't have to manually spot check between both. I created a new Column called, "On Escalation Master?" and want to return a Yes or No value. I am getting #UNPARSEABLE error when I try…
-
SCC suddenly very slow on provisioning
What are reasons that may cause provisioning to slow to a crawl? previously the provisioning worked fairly well and would finish with a link to jump to dashboard. Now suddenly as of yesterday the provisioning is crawling and seems to stick at the "running Rollup/Summary" stage which then finally times out with an error…
-
URL instead of Display Text for SCC Project Dashboard?
When a project is provisioned in SCC it generates a dashboard link using whatever naming convention is setup in SCC. It doesnt appear to have any options in SCC to make it appear as a url instead? I also am checking the column properties or formulas for a way to make this a URL? The problem is that once a Dashboard Link is…
-
How to start time on a project and prompt for a list of tasks
Hello. Our Implementation Team is asking for a timer of sorts to capture their task time (whether onsite at clients or remote support). At the beginning of work on a specific day, the Implementation Tech would hit a start time button, then - they will work on their assigned tasks that are listed in our Smartsheet project…