-
COUNTIFS+CONTAINS
I get the message UNPARASABLE, what am I doing wrong? I want to count the non blank fields in rage 1, when in range 4 I have a certain value AND is the range 7 = OPEN value. =COUNTIFS({Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 1};<>"";[{Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 4};…
-
Strange Formula Behavior
Greetings, I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information into three sheets. My solution converts the times in each sheet correctly: Above is a portion…
-
Setting up a trigger comparing today's entry with the last entry.
Operators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes. How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the last time it was entered? Example below.
-
Trouble with long, nested formula...
Trying to have a column show status of requests, and have been having issues for days. IF [Provisional Requested Amount] is under 50000 and [COL Leader Approval] is Provisional Approval = Provisional Approval IF [Final Requested Amount] request is under 50000 and [COL Leader Approval] is Final Approval = Final Approval If…
-
Date range formula
Hello, How would i write a formula when looking for data between a certain period i.e. I want to find the number of tasks marked 'complete' between March 1 through March 31? Thanks.
-
HREF in Automated Emails
Hi. I am trying to change the content in the email to be "Click Here for Web Form" as the url is for a form with prefilled files in the form, which makes the URL quite long, but some email clients dont recognise it as a full url. Looking at trying to do similar to HTML where the below: <p><a href="google.com">Click…
-
Pulling Column Info Based on Column Containing Data in Separate Sheet
I am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been trying to figure it out and have seen that I probably need to use the INDEX and COLLECT…
-
JOIN function for child row
Hi everyone, I'm currently working on a way to leverage formulas and row hierarches to create a ROW ID column. Essentially what I would like to happen for children rows to have the same "item ID" as their ancestorial row. This is what I have so far for the parent and child row formulas (currently seperate) Parent…
-
Concatenates in Smartsheet from Excel?
I'm in the process of moving my teams over to Smartsheet and having some difficulty migrating over information from excel that has excel formulas. Is it possible to combine multiple cells and add in a symbol, such as |, between two sets of data? The excel formula being used is: =IFERROR(CONCAT($A7,", ",$B7," | ",$D7),)…
-
Formula to change the Health status of my projects based on data from two cells
I'm trying to get a formula that will change the Color dot in my Project health status field, based on conditions in two other cells. What I want is: If the "Project Status" field = Active or On Hold, AND the "Project Wrap Date" field is Today (7), change the Health Status field to a Yellow dot; or if the "Project Status"…