-
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"…
-
Linking / Updating Sheets
Afternoon All - I have a slightly complex question I wanted to pose to the community to see if I could get some thoughts. I have two sheets that I want to have "talk" to each other. One Sheet (Master Sheet), is where our team spends their day looking for requests to come through. In a second sheet (Change Requests Sheet),…
-
Formula to calculate total sum from a hierarchy column criteria
I have the following sheet that I want to calculate the sum of "Number of slides" which appears in the hierarchy translation column. I've done this same thing with only counting the instances instead of summing them, but I can't get the formula to work for the sumif in the same way that the countif formula worked before. I…
-
Extract Series of Occurrences of Strings into Separate Columns
Hi @Paul Newcome , You mentioned in another thread here: https://community.smartsheet.com/discussion/63606/extracting-string-from-a-cell? "If you wanted to parse them out across individual columns, we would instead use a series of LEFT/FIND and MID/FIND statements." The previous thread looked to me like someone was using…
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheet…