-
Populating a Number Value based upon a CONTAINS condition
I am collecting feedback from a series of clients. I am separating each client by their revenue number to show the satisfaction rating for each "tier" of our client base. As such, I am trying to find a formula which will populate their revenue number value associated with their specific client number. For example, client…
-
Help with COUNT and DISTINCT function
Hi team - I have a column called Agreement # that has various agreement numbers in them but also many duplicates. I'm trying to get a count of unique numbers but when I combine the COUNT and DISTINCT functions - it keeps coming up with 1. The Agreement # column looks like this (example): Is there a problem because there…
-
Counting cells with numer of %
Hi i want to count the number of cells with 100% i.e i have 20 projects that have reached 100%. i tried =COUNTIF([% Complete]1:[% Complete]118, (100)) and also tried =COUNTIF([% Complete]1:[% Complete]118, "100") but it doesnt return the correct number. Thanks Paul
-
General Dashboard and Widget Question - Moving Groups of Widgets
Is there a way to move multiple Dashboard elements or widgets all at once? I'm finding that I have several "metric" widgets on my dashboard and currently I haven't found a way to "select all" and move them as a group. Instead I am currently having to move all of these widgets manually one at a time which can be tedious -…
-
Single Unit Drop Down
I have several single unit drop down lists, yes or no, etc. Is there a way that SmartSheet will automatically display a chosen unit? Such as, a column will always appear as no unless changed to yes? Thanks
-
IF-formula on a date range
Hi guys, For the last couple of days I've been trying to create a simple formula, but in some way it doesn't work. I want to check if the date of today falls inbetween a specific date range (2 different columns), using the IF-formula. I've tried this formulas: =IF(AND([Date 1]1>=TODAY(),[Date 2]1<=TODAY), "True", "False")…
-
Automating count formula and trend summary
Hello All, I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has a status column reading either “active” or “not active.” At the end of each day, I am manually totaling the number of active…
-
Return user name for latest date created
Hello, I have a sheet that populates from entries by a form. I would like a formula that tells me the name of the user on the very latest entry. I've tried various combinations but can't seem to get the right one that returns the users name. Could someone please assist me? I have a User Column, Created Column (auto…
-
Data Uploader - status won't change if someone has made a manual change previously
I have a tracking sheet of client account numbers. We have one Status column that has options such as "Faxed" "Complete, waiting for download", " Complete", etc. I have my formula set up so that the status column will change, and it works ONLY if no one has made a manual change to the status previously. To clarify - we log…
-
IF condition statement from multiple columns & properties
Need help populating the right color in my status column, which uses Red, Yellow, Green circle symbols depending on what other columns are reporting. I assume the below could be written with a formula. IF column B is blank, then RED. IF column B is not blank, then Yellow. IF column C is checked, then Green.