-
Cross-sheet references with Index/Match and reference sheet has multiple rows that match
Sheet A: Formula in Data: Ent. Install Time: =IF(CONTAINS("Enterprise 2022 R1", {AtRiskAnalysis-Version_Version}), INDEX({AtRiskAnalysis-Version_EntInstallTime}, MATCH(CustomerId@row, {AtRiskAnalysis-Version_CustomerID}, 0))) Formula in Data: EDIS Install Time: =IF(CONTAINS("EDIS 2022 R1",…
-
Is there a rule to change Priority in a Column, when Due Date in another column is within 30 days
I have a sheet set up with a list of tasks One column is dedicated for "Priority" *High, Medium, Low" Importance. Once column has due dates, for each of the line item tasks Is there a rule or formula that can be crated where the Priority can change in the individual cell of the line item, when the associated Due Date, in…
-
How do I get my Project Metadata pulled over accurately from our intake sheet?
I've looked at many posts asking the same question however, I still can't figure it out. In my mind, I feel like I should be able to update the Project ID or Project Title on the metadata and it should pull the relative row information from the intake. Each time I start with the formula, I click the highlighted items and…
-
How do I write a '% Approved' formula for two conditions?
How do I add a second condition of Category = SD to this formula in my Sheet Summary to calculate the % of SD Approved? The first condition is Status = Approved. =(SUM(COUNTIF(Status:Status, "Approved") / COUNT(Status:Status) * 1)) I know this is probably simple for most, but I'm new to creating Smartsheet formulas. Thanks…
-
How to parse/separate multiple contacts
Our project plan has a resource field that can have up to 5 people/contacts assigned to a task. I am looking for a way to scan the field and pars/separate the resources into individual columns (example in red box below). I know it may be a strange request, but for our org, it does make sense. 😉 Here is the formula I tried…
-
Formula to split up / break down long strings of text
Hi, Hope you're all keeping well. I was hoping someone could point me in the right direction of a formula / function that can help break down large sections of text. If someone could point me in the right direction, I should be able to work out the nuances and implementation myself. I have an API that exports data into a…
-
Activate/Deactivate a Checkbox
Is it possible to activate/deactivate a checkbox, based on the value in another cell? For instance, I have a sheet where users enter data via a form. Then there is a "DQ_Check" column with an IF statement that returns "TRUE" or "FALSE" to indicate that all required fields are valid. If that statement returns true, I want…
-
Date Format Not Saving When Using Formula
Hello, I am using a formula to extract a date from a string of text. It appears to be working, but if I leave the sheet and come back later it continually reformats the date from MM/DD/YY to YYYY,MM,DD. The target columns are formatted as dates, and the original column is a dropdown list. I can change the target column…
-
Assistance Needed: Setting Up an Alert in Smartsheet for Unassigned Audits
I'm currently working on optimizing our workflow in Smartsheet and could use some guidance on setting up a specific alert mechanism. Our team manages incoming audit requests through Smartsheet, and we're looking to improve our response time for these requests. If an audit hasn't been assigned within an hour of its arrival,…
-
Inconsistent Formula Issue #INCORRECT ARGUMENT SET error
Hello, I am working in a sheet summary and I am using a formula to count the number and type of maintenance issues after a certain date. My issue is that I am using the exact same formula in different fields in the sheet summary and only changing the text in a countifs formula. It works in some cases but not others. For…