-
Sheet Summary
I would love it if Smartsheet had a more robust sheet summary, rather than creating those using formulas on the grid, or creating a dashboard to pull in those summaries/formulas from numerous grids. The sheet summary on the right menu often doesn't capture all that you would like and give limited flexibility in capturing…
-
Show dealy in gantt chart
Hi We are trying to use Gantt chart, for planning a project timeline. We have expected start, actual start, planned end date and actual end date, because sometimes something gets in the way and we can't hold the original timeline. But we want to know how much of a delay we have or doesn't have. So we use the dates to…
-
How to Build Nested ISBLANK or NOT ISBLANK Formula?
I want to build a row formula in the Itinerary helper column that evaluates a the series cells in 7 adjacent columns (Camping & Hiking thru Wilderness Medicine Classes). For example: When the formula works - Itinerary Helper column on Wilderness Medicine row = Wilderness First Aid. In this instance only 1 of the 7 cells in…
-
Hi community! I am trying to understand if SM can be used for 360 degree /peer feedback
The key requirements of the system will be : 1) Peers will be sent feedback requests via SM forms, where they will submit feedback on pre identified peers. however feedback providers may not have SM liscenses or accounts . A) Can folks without SM accounts submit forms? B) how to set up my sheet to ensure that that feedback…
-
Trying to get an Avg $/Hr with a specific task type, Date range, & assigned to.
=AVG(COLLECT({SOS - $/Hr}, {SOS Task Type}, =[Task Type]7, {SOS Project Closed}, >[Start Range]1, {SOS Project Closed}, <[End Range]1, {SOS Assigned to}, =[Assigned To]2)) Gives #INCORRECT ARGUMENT SET. Using AVERAGEIF is #UNPARSEABLE Thanks for any help
-
CountIfs with Date Range on Multi-Select Dropdown
I was hoping to be able to find the answer elsewhere but have had no luck. I was able to build the following formula from other answers but stuck on the last part of the criteria (Warning Items) being in a multi-select drop down. So the formula works but is incorrect in that it does not count cells where there is more than…
-
Invalid Operation on nest if formula
I've used the nested if formula a number of times, but can I get it to work for this one? Nope! I have a single select dropdown column with statements. In another column, I want the statement to return a different text value. The only time it works is when the first option (first IF statement) is selected. Could it be that…
-
Conditional Formatting Calendar Tasks Excluding Parent
Hello, I was hoping someone can help me figure out why my conditional formatting conditions are not formatting parent rows. In the attached example, my conditional formatting will highlight the task bar a color if "Level = date range" and "Dates Confirmed = Green". When I change to "Calendar View" I notice rows 65, 68, and…
-
how do i do a formula to count two different variables?
Hi, I am trying to create a formula that will give me a count if two different variables are true: I have 2 different columns 'Resource' & 'Status' I need to pull data that will portray how many jobs a person has when the status is 'in studio' i.e for 'k' should read 1 as it's in studio but for 'j' it should read 0
-
Clear Contents of Cells if value = 0.00
Good morning, I'm working on a budget sheet. I have a form that uses logic to split between "expenses" and Credits. If there is a credit, the form will ask for the purchase amount. The purchase amount will then be multiplied by .85. to determine the credit total. My [Return Credits] column has a formula to calculate…
