-
Range of data
Hello, I'm looking for a simple, at a glance range of data. Example, column contains numbers from 150 to 4, with 23 rows (more rows be added as completed) that are from formula. List of 2 numbers: Largest and Lowest numbers. List of spread Large to Low and vice versa. I tried RANKEQ formular, but unable to make it work.…
-
formulas
Im trying to calculate the remaining amount to be billed on a project based on the Job % of completion, factoring in the original contract amount, the deposit and remaining amount that is due
-
Need some help with a COUNTIFS statement looking for one OR another
Hello I'm trying to figure out how to use an "or" with a COUNTIFS statement. This formula is looking at the “Amendment” column for “2018” contracts, and I want to return how many in the amendments column have a value of X or Y. It works for X, but I don’t know how to add the “or Y” to it. Here's what is there so far:…
-
I need a formula to find the average of the Count of Training IDs
I have a grid that intakes via a form, training evaluation answers. Each row of responses has a TrianingID associated to a specific training. I have been ask to find the medium average if the number of responses received per trainingID It needs to be a column formula due the new TrianingIDs populating as more and more…
-
Dashboard Sharing
Hi All! Aside from sharing it using a public link, I was pretty sure that dashboards functioned like reports, where a user had to have access to the supporting/underlying sheet to access the information. Has that changed? And if I was wrong from the beginning…I guess my real question is: I do not want to make my dashboard…
-
Workflows - Ordering/Sequencing
We need the ability to apply a sequence/order to Workflows. We have situations where two separate workflows have their condition met at the same time, and both of their outputs are targeting the same field (updating a status field, for example). We have no way of controlling which of these workflows take precedence (or…
-
Assigning people in smarsheet
Hello, Does anyone knows why some names shows up as their name and some shows up as their email address even though I have added them in the contact? Thanks!
-
Freeze Column in Dynamic View
Hello Community; Is it possible to freeze a column in a Dynamic View? Like in a sheet or report, you can freeze a column to make it easier to scroll to the right and still have visibility of the first couple of columns...
-
adding and subtracting from inventory sheet based on orders
Hello, what im trying to accomplice is when selecting a item in the drop down menu "equipment shipped" for example "logitech". i would like it to subtract a quantity of 1. example, we have 200 and in our inventory sheet. i would like it to look at our inventory sheet and subtract 1. i would also like to do this with if we…
-
Why am I not able to summarise a column in a report?
I am trying to summarise a column in a report. The column is a Text/Number formula that says 'Late' if an enquiry is late. I just want it to count how many late there are but Smartsheet isn't letting me. Often the option to summarise this column isn't there but if I remove and add it again, the option appears but it…