-
CountIF using 1 of 10 count up
=COUNTIFS(Status:Status, "Complete") + " of " + COUNTIFS(Status:Status, NOT(ISTEXT("Complete"))) The above formula is the parent on the Status Column. I want it to be similar to the Done column. As you can see the numbers don't match up. I have figured out the child COUNTIF but I am struggling to add up the numbers…
-
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…
-
Complete Through Progress Bar
My organization is moving from MS Project to Smartsheet and there is a functionality on the progress bar of the gantt chart in MS Project that I would like to see if Smartsheet can do. The Update Progress bar that shades % Complete in MS Project can be set to show Complete Through progress (the functionality is detailed in…
-
Importing from Excel to Smartsheet (Grid) using names for contacts
I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would like them to come in (during the import) as SS contacts (name, icon, email shown and can be used…
-
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…
-
Auto File Number
I have a web form and every time it submits, a new row is added to the top of the sheet. A file number would appear as follows: 20ExC-001 The formula I use is: =IF(Department1 = "Privacy", "20ExC-001", " ") My question is, how can i ensure that every time the form is submitted the last three digits increase by 1, such as…
-
SUMIFS Cross referencing Help
I keep getting an "incorrect arguament" or "inparseable" return when trying to sum up the amounts in a given range based on 3 criterion. The sum range & both criteria are in another sheet. The first criterion is a simple "greater than zero" and works well. The second criterion is looking for the word "Approved" and does…
-
Countif - Multiple outcomes?
Hi, We run a design Dept sheet accessed by 5 sales reps who can select 1 Request Type from 10 set options that don't change (RT column) IE: Drawing OR Drawing and costs OR TSR OR Permit etc.. These I count easy enough rep x rep (countifs) with that data displayed on a dashboard. When a RT is assessed by the design team it…
-
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
-
Issue tracker: Average Days to Resolve based on a time calculation on another range
I have an issue tracker sheet that includes SubmittedOn (Date) and ResolvedOn (Date) columns. I created a DaysToResolve column that counts the NETWORKDAYS (SubmittedOn, ResolvedOn). I am trying to build a dashboard that shows the Average DaysToResolve issues created this week, last week, etc. I have tried AVERAGEIF,…
