-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tried it just text) off all the dates each work type has work. I am then on a separate…
-
Add a Formula to a Cell Using Automations
Is it possible to add a formula to a cell using an automation? I attempted to do this using the Change cell value action, but it only adds the formula as text. The sheet does not recognize it as a formula even though I did start it with an "=". I'm trying to populate the value of a cell with data from a cell in the same…
-
IF and Conditional Formatting
I have some conditional formatting set up so the field crew can make the needed measurements. I have a formula in the Delta column that adds up the measurements and subtracts that from the Qty for each column. I have an Automation that sends an email out if the Delta is above a certain threshold. I don't want the Delta…
-
Auto Generate sequential # to different Project ID category
Hi there, I am looking for a formula or a solution to auto generate Project ID with sequential # once Project Type was chosen in Intake Form. I described what I would like to achieve in detail in an attached document. Could you kindly take a look at it and let me know if this is something SmartSheet can handle? Best…
-
How to capture time elements from a form and display on a dashboard.
Good morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out If I can or how to auto populate the results for a single time element in my sheet…
-
Consistent [Column Name] Formula
Hi, Is there a way to add like a string "[Column Name]" so whenever I add a new column that has that name the formula stays refrenced to that new column with the same name? Thank you!
-
How can I count distinct values under a same month?
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this case I would only like to count the unique TR ID's for the month of August, 2020…
-
Excluding two values for Sheet Summary Formula
Hi all, I was wondering whether you might be able to help. I have a column "Status" and I would like to write a formula for a sheet summary field that counts the number of status' that are anything other than "On Hold" and "Complete". I've tried various COUNTIFs but none seem to be working! Any help on this would be great!…
-
Formula Error
Hello, I was hoping to get some help with a formula. We are using INDEX/MATCH. Its all working great when we are referencing one column. When we change the reference to select a range of columns, the formula doesn't work and we get #UNPERISHABLE. Can someone help us figure out how to reference a range of columns? Here is…
-
Adding text to a field, then changing text color based on calculated values
Hello. I would like to ask if anyone has had an opportunity to have text added to a column, then based on a calculated value, change the text color from say black to red based on a calculated outcome. For example. I have a checkbox that simply determines if multiple Techs were required for a specific task. If the checkbox…