-
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!
-
How do I search for duplicate data within a sheet?
Hello everyone! I am very new to Smartsheet and new to my position as a New Product Development Coordinator. My company utilizes Smartsheet to track new ideas for products as well as the progress of the projects done on them. We have a master sheet that all the ideas are filled into from a form showing who submitted the…
-
Automatically change status based on % complete and date
Hi I was wondering if someone could help me put together a formula to automatically change status I am trying to setup the following and keep getting errors. If % Complete is 0% Status should be Not Started If % Complete is blank Status should be blank If % Complete is n/a Status should be Reference Only If % Complete is…
-
Index Match with If Statements
Hello, I have a formula question. I have external employees who do customer visits and repair visits. For every visit they enter a visit detail and when the primary reason for the visit is Repair/Troubleshoot, they have to do a repair detail. To keep them from having to reenter shared info, I did an index match formula…
-
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…
-
Looking to return multiple row values from another sheet based on dropdown selection
Greetings, Community, I'm wondering if there is a way to return data sets of multiple rows based upon a drop-down selection from a form. What I'm looking to get to is I have a form for people to request testing on programs they implement. In another sheet (I'll refer to as the KPI sheet), I have the programs (primary…
-
Summarize tasks for assigned teammate on an intake tracker
Hi there - I am not understanding how to use this COUNTIFS formula above. I am in the process of creating a SmartSheet dashboard for my team from an intake tracker we have. I would like to use the metrics widgets which require sheet summary formulas. Problem - I am trying to create a sheet summary of how many current tasks…
-
Formula that triggers flag if any cell@row changes color
I have multiple very long complex sheets with a lot of data. With conditional formatting, many cells will change color when there is an issue with a date, number, answer to a form question etc. Having the whole row change color or scanning through all columns/rows looking for issues has proven to be too cumbersome. What…
