Best Of
Re: Global Update Troubleshooting
Global Updates to Dashboards will ask you to first Test the update on one single Dashboard. Could this be the "choose a dashboard" page you mentioned?
After you've chosen a dashboard and applied a test update, there will be a prompt to Open Test Dashboard.
Only once you've open up the Test Dashboard (which will be a new Dashboard) can you click "Confirm" in the bottom right corner to then select and apply the update to all your actual Dashboards. The new, test Dashboard will then be deleted and put in your Deleted folder.
Is there a possibility that you may have opened the Test Dashboard without coming back to click "Confirm" to apply the change to all your other Dashboards? This Test Dashboard will look identical to your real ones, but it will have a different URL that's not linked in your Intake sheet.
Let me know if this helped or not!
Cheers,
Genevieve
Genevieve P.
Re: IF(AND - Error, Unparseable
Hi @Holli,
It looks like there's a syntax error in your combined formula. Try this instead:
=IF(AND([Pay Schedule]@row = "GA-Full Session", [Hrs Per Period]@row = "5"), 160, IF(AND([Pay Schedule]@row = "GA-Full Session", [Hrs Per Period]@row = "10"), 330))
In your combined formula, you're missing the second "IF" statement within the AND function, and the second "IF" statement itself is missing the "@" symbol in the [Hrs Per Period] column reference. This corrected formula should work for you.
J Tech
Working with Symbol Formulas
Hello Smartsheet Community! As our Community grows, I am starting to see some trends about features and workarounds users want to learn more about. For these topics, I am starting a new series of announcements. In this series, I will write about trending topics and topics that you request! After I post about a subject, I can answer any questions you have or go into further detail on any aspect of the topic.
Welcome to the first of this series -- Working with Symbol Formulas
This post will teach you how to build formulas with the new symbols that were added a couple months ago. If you learn the basic syntax of building a few different formulas, you can take the same formula and change up the wording to make the formula work with any symbol type.
We will start with basic IF statements that work like this:
=IF(*this* is true, then do *this*, if not then do *this*)
=IF(logical_test, value_if_true, value_if_false)
Here’s a simple IF statement located in a Flag column that will enable (1 = enabled) the flag if the referenced Due Date is in the past:
=IF([Due Date]2 < TODAY(), 1, 0)
This same formula can be used with any of our new symbols. Let’s use the weather symbols and display the Stormy” symbol if the Due Date is in the past and Sunny” if it’s not:
=IF([Due Date]2 < TODAY(), “Stormy”, “Sunny”)
My next example is a little more complicated and will show you how formulas will basically stay the same across different types of symbols, like Progress Bars, Hearts, and Stop/Rewind/Play symbols.
We will be using nested IF statements, which are multiple IF statements combined in a single formula. This gives us more options for the formula results. Here’s how they work:
=IF(*this* is true, then do *this*, IF(*this* is true, do *this*, IF none are true, do *this*)))
=IF(logical_test, value_if_true, IF(second_logical_test, value_if_true, value_if_all_false))
Here’s what the formula will do in these examples:
If % Complete is 0%-24%, *first option*. If 25%-49%, *second option*. If 50%-74%, *third option*. If 75%-99%, *fourth option*. If 100%, *fifth option*
Progress Bar:
=IF([% Complete]2 < 0.25, "Empty", IF([% Complete]2 < 0.5, "Quarter", IF([% Complete]2 < 0.75, "Half", IF([% Complete]2 < 1, "Three Quarter", IF([% Complete]2 = 1, "Full")))))
Hearts:
=IF([% Complete]2 = 0, "Empty", IF([% Complete]2 < 0.25, "One", IF([% Complete]2 < 0.5, "Two", IF([% Complete]2 < 0.75, "Three", IF([% Complete]2 < 1, "Four", IF([% Complete]2 = 1, "Five"))))))
Stop/Rewind/Play:
=IF([% Complete]2 < 0.25, "Stop", IF([% Complete]2 < 0.5, "Rewind", IF([% Complete]2 < 0.75, "Play", IF([% Complete]2 < 1, "Fast Forward", IF([% Complete]2 = 1, "Pause")))))
If you can learn how to build formulas for one type of symbol column, you can build formulas for any symbol type. The trick is just learning which terms are related to what symbol. An easy way to do this is to add the symbol column to your sheet and click the dropdown arrow in one of the cells to display all the options and the wording or by checking out this Help Center article on the different symbol columns available.
Travis
Re: Automate label/ name addition in primary column
Put your start date in a summary field (little sheet icon with a tab on it to the right/center of your sheet) for ease in changing data in bulk - keeps you from having to edit the formula constantly
Formula column (called [Weeks] in the example below) =ROUNDDOWN(IF([email protected] = [Start Date]#, 1, IF([email protected] > [Start Date]#, ([email protected] - [Start Date]#) / 7, "n/a")), 0)
[email protected] is the start date field in your sheet
[Start Date]# is the summary data (seen on the right)
Once you've built this out, you can just build a report that shows you a breakdown for a single week, series of weeks, or break the job up into weeks.
Austin Smith
Re: I think I need a count formula
Hello @Voyage1,
Have you tried a COUNTIF with their ID? On sheet 1, next to their name, or whatever, do =COUNTIF(Name:Name <Reference Sheet 1's Name Column>, [email protected] <Reference the Name in Sheet 2>).
Eric Law
Re: Smartsheet Summary
@Frank B. You will need to remove that error from the column using an IFERROR statement to output either a blank or some type of text string instead of the error.
=IFERROR(original_formula, "text string")
Paul Newcome
Re: Cross Project Dependencies
Hi @LPelser!
No, they did not. What I did was create a task "Ice Cream Freezer Acquisition Complete" in each of the other projects and then used the "link to another sheet" to pull in the completion date from my Ice Cream Freezer project.
I have the completion tasks in the other projects depending on the created task mentioned above. Almost too simple, but it works. What I can't see though is the uber critical path via Smartsheet. I have Visio drawings that I refer to to help identify the impact of slippage risk. I hope this helps!
PattiL
Re: Is this possible in Smartsheet?
You would create a sheet that has each benefit listed out and then use a JOIN/COLLECT to pull in the various projects, etc. associated with that benefit.
Paul Newcome
Re: Smartsheet Pivot App & Calendar Apps
I hope you're well and safe!
You'd have to continue subscribing to the Pivot app to use the Pivot feature.
The Calendar App is fantastic, but if it would be helpful for your need depends on your specifics. How would you like to use the Calendar?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Auto checkbox formula for a date
@laura.sandoval Why don't you use the change cell automation, whenever a row is add/changed, filter SQV Date not blank, change cell SQV Scheduled is Checked.
Eric Law
