-
Precentage of Cell 2 out of Cell 1
Hi, What formula caculates the precentage of [Column A] row 1, out of [Column B] Row 1 Thank you!
-
Help with dropdown menu lookup
I'm looking to create a dropdown menu that pulls from a list of another sheet, is this possible with SmartSheet? Meaning, I want to be able to constantly update a SmartSheet list without needing to also update the dropdown menu. Thanks for your help.
-
Trying to average "STM Task" values where "Position" is one of two options..
Thought this one would be straight forward but so far I have tried the following without success: =AVG(COLLECT([STM Task]:[STM Task],Position:Position,"Adjuster - UV",Position:Position,"Adjuster - Web")[STM Task]:[STM Task]) =AVG(COLLECT([STM Task]:[STM Task], Position:Position, "Adjuster - UV", Position:Position,…
-
Project Health Formula Help
Hello, I've been struggling with this formula. I borrowed parts from other project tracking templates, but I can't seem to get everything to work together; I keep getting error messages. I'm looking to: Project Health turns "Green" for any row that has a Status of "Complete" or if the Target End Date is 1 week out or…
-
Is there an opposite way of writing an IF(ISDATE...) formula?
I have the following formula used in a sheet to change RYG symbol colors based on a targeted date status. =IF([Due Date]@row < TODAY(), "Red", IF(AND([Due Date]@row >= TODAY(), [Due Date]@row < TODAY(+7)), "Yellow", "Green")) This works, however - I need it to stay BLANK if the status is a certain setting OR if there is a…
-
Email automations in report not working
Hi. I need help with setting up a report to send monthly to specific email addresses every month. I saw others recommendations on automating the "Send as Attachment" in the report, which I tried and it is not sending the reports. Here's the steps I tried: I created a report "Gas Receipts Monthly Report" which will send a…
-
Date Formula for Xth Day of the Month
Hi there! I'm hoping for a formula that returns the third working date of the month. I do have dependencies enabled, but none of my dependencies stem from this row. Seeing as how others will use this sheet monthly, it would be nice if rows like this autofilled monthly to avoid some manual work. In my dependencies, I have…
-
Adding fake user in a multiple contacts per cell field configuration
I have a sheet set up using the Contact List field to hold my Assigned To information. I have a set of named resources and associated email addresses for some individuals , which works fine in a multiple contacts per cell configuration. These real users are Users under User Management/saved in the sheet Contact List. I…
-
SUMIFS with LEFT as a reference
I'm looking to sum a range as long as 3 criterion are met. 1 of those criterion is that Left of another sheet reference (4 characters) match a cell (could be text in the formula as well). =SUMIFS({Time To Assemble}, {IPK}, [Machine Type]@row, {Progress}, "Finished", LEFT({Item Number}, 4), [Machine Type]$17) This is…
-
Simpler Fiscal Year and Quarter Formula
Hi, Admittedly, I'm very new when it comes to spreadsheet formulas. I was given this formula for fiscal year and quarter calculations but I was wondering if there was a simpler way to do it. Also, it's in a calendar year format and our fiscal year is July 1 to June 30. I appreciate your help. =IF(ISDATE([Completion…