-
How to append sheets/consolidate multiple sheets in one sheet
Hi All, here are two different sheets populated from two different forms which are site specific The forms have information for people to read which are site specific hence why two forms Is there a way to append these two sheets into one like you can do on power bi using the append query function? please can you advise
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…
-
Does Data Shuttle's Upload Data work in a sheet that has column formulas?
Hello! I've been having successful experience using Data Shuttle Upload Data with sheets that are referenced in another sheet. Now I have a sheet (sheet name: Tracking) with multiple column formulas, Data Shuttle Upload Data work doesn't seem to work... When I try to set up the workflow, the columns that are formula driven…
-
Formula Help Needed to Remove 0 From Results
Hello Smartsheet Community! I need some help to better understand what is happening. Why are only some of my results generating a leading 0 in front of my text? I have a multi-select column with a variety of text values for more than 20 groups. In the same sheet, but in different columns, I have written out a formula to…
-
Formula for checkbox column
Hello, I need a column formula that check marks all the children rows if the main parent row is checked. Thanks!
-
At risk flag formula help (please!)
Hi there, I am attempting to enter a formula in a flag column to automatically show at risk (red) when tasks are overdue and not 100% complete AND when due date is within 7 days and the %complete column is not 100%. Attached is a screenshot of what I have taken a stab at, I am not amazing at multiple condition formulas so…
-
IF formula issue (again)
I though this would be an easy one but it has me stumped again... So i now want a column to populate with a symbol based on an other columns status to give a pictorial representation of that status, is this possible? i.e. The symbol option used was from the 'Status' section and was the empty circle running through to the…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…
-
Formula Error
Hi Community, I needed to adjust a formula to perform an OR function instead of an AND function and now I'm receiving an error that I can't seem to correct. The issue lies in the first section of the formula to produce a "green" value if true. Any help would be greatly appreciated!
-
Dollar values keeping the comma delimiters
I repurposed the formula to this below. Now I have a range from 10's of thousands to 100's millions. how do I not get that final comma next to the period automatically? ="$" + LEFT([Unit price]@row, IF(MOD(LEN([Unit price]@row), 3) = 0, 3, MOD(LEN([Unit price]@row), 3))) + IF(LEN([Unit price]@row) > 3, "," + MID([Unit…