-
What's wrong with my RYGB formula?
Ok, I'm feeling really stumped. I have this formula for changing the color of the RYGB balls based on the number in a specific cell but it is returning an #INVALIDOPERATION on anything except zero (when the ball turns blue). Where am I messing this up? =IF([# of Days from Submission to Assignment]@row = 0, "Blue", IF([# of…
-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?
It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column: =IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE…
-
I can't figure out how to use the OR function in a Countifs formula
Hello, I have been creating metrics on my data in smartsheet using the different formulas. I have figured many out (with a lot of head banging and sleepless nights), but cannot figure out how to use the OR function. works: =COUNTIFS({Week}, =$[Date Range]$3, {Month}, $[Date Range]$5, {Year}, $[Date Range]$8, {task status},…
-
Is there a way to auto sort data on a sheet (cannot use report) to show the Largest to Smallest?
Hello, I am creating dashboards using metrics and am trying to figure out a way to only show the top 15 of specific data. Sheet details: I have one column that contains 298 different locations and the next column is the # of issues at that location for last week. I have the formulas figured out to pull in the metrics…
-
Auto filling a Formula
I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name. I am wondering if it possible to auto fill the name portion of the formula from another cell. The formula looks like this: =COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned…
-
If statement based on date
I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19". =IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19" I am using the date format (2019, 8, 25) based on what…
-
Limit Dropdowns Based on Previous Input
Is there a way to create or limit a dropdown based on input from previous field in Web Forms? So if the user chooses makes a selection in Dropdown #1, I want to tailor the options in Dropdown #2. I I know you can do this in Excel, but now sure here. Newbie and looked through community and help --any advice would be…
-
Problem adding countifs
I'm trying to count projects that have either a four or five priority and this formula works: =SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five")) I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't…
