-
Ratio-Based Conditional Task Health Indicator
Hi I'm a bit embarrassed to ask this, as it seems so simple, yet I've been searching high and low for an answer so am resorting to posting a question. I'm relatively new to SS and find the conditional logic interface a bit clunky and hard to use. In summary, I've created a R/Y/G indicator column and am trying to work out…
-
Search for specific words within texts
Hello community, I would like to know if within the smartsheet there is any way to search cells through specific words, using a count formula for example. Within Excel we use * to search for a word that is together with others. Example: =COUNT.SES($C$31:$C$67;"Day by day*";$D$31:$D$67;E280) This formula brings the count of…
-
IF Formula to determine current + next months coming up
I'm looking for a way to create the following: I need to add an identifier that says within the next two months, and then another one that says the next three months nut not including the current as I have that already separated using the formula below. How do I count out 60, 90 days to call them next 2 months, next 3…
-
Help With Multiple If Formulas
Hi, I am attempting (Badly) to put together a formula to set dates based on a previous date, but also the timeline is based on a yes or no answer, so if the answer is yes there is one timeframe and if no there is another I also don't want errors if the field is blank. So far I have this; =IFERROR(IF([Client review…
-
Counting records based on Created month
I want to count the records created based on "created month" column. =COUNTIFS({Status}, [Primary Column]@row, {Created Month}, "APRIL 2023") I tried with to calculate for one month but I wanted to calculate for all 12 months,
-
How do I extract full URL from Hyperlink cell?
Hi all I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink. I need to send the Salesforce URL to another sheet, but if I…
-
How to extract the data from the another sheet?
I am trying to find out the formula that help me to list out how many trading partners that we are currently working on it. The list should not be duplicated and it will be Renault, Titan X, Volvo. Can someone please help me?
-
Pull in "Features" with a "Priority = 1" into a Master Sheet
Hi there, I have a Smartsheet problem I am having a hard time figuring out a plan for... Essentially, my Product Owner has 2 different backlog sheets she likes to keep, let's call them: -Backlog A -Backlog B Now, what my Product Owner wants to do is create a "Master Sheet" wherein she can pull in features from both Backlog…
-
Cross Sheet Formula's
I am struggling with a formula, I have watched several videos and read posts from others and I still cannot figure it out. I want to pull all the costs for a specific boat (location) and have those costs (extended cost) added together on a summary sheet.
-
Formula Help: Do This Week, Do Next Week
Hi, gang! I need to create a formula that populates Do This Week, Do Next Week, Do Three Weeks for my boss. I have Start and Finish date columns as well as a dropdown Do column with those three as options. We're not looking for reports, but rather this summary view in Card View for him. Thank you for your help!