Best Of
Re: I have been manually keeping a running total and want to apply a formula based on expense total. How
Not a great answer as you cannot make it a column formula, you could use "=[Expense Total]@row" for the first entry. Or just enter in that amount. Then for every cell after that use "=[Expense Total]@row+[Running Total]1".
The main problem is that you will have to have it copy down each time you add a new row. But if you select the last cell with the formula, you can drag the little square to fill in all rows below. It would save having to enter in a formula each time.
Matt_A
Re: Has anyone made a short cut sticker for computers for smartsheet?
@Joe Goetschel thanks for sharing! I have the one from Engage on my desk right now.
EEK
Re: Has anyone made a short cut sticker for computers for smartsheet?
@Joe Goetschel Thanks for sharing
Isis Taylor
Re: if statement based on another column
I think you'd need a nested IF statement:
=IF([RML STATUS]@row = "RML-Current", "ACTIVE", IF([RML STATUS]@row = "IN-TRL", "ACTIVE", "INACTIVE"))
WMS
Re: Data shuttle - how to update with recurring reference column
hi @22Wordsmith,
If you cant use DataMesh but you want to have like DataMesh functionality why not going into TableView and use the Link Column functionality there? It will fill your data automatically.
kowal
Re: Has anyone made a short cut sticker for computers for smartsheet?
Hope to have something cool this year!!
For anyone that needs it, here is the digital version of what we gave out at engage! We are now officially part of CrossCountry Consulting now :)
Joe Goetschel
Re: Celebrating Milestones
Hi @rebecca.collins !
Are you looking for something automated? Or something for a one time use? If it's just one time, you could drop a large image widget onto the dashboard with a fun graphic.
For something automated, you could use a formula to determine if the criteria has been met, and if yes, have a metric widget that displays a bold announcement highlighting the milestone.
Sam_Harwart
Re: Projects that repeat
Like most things in Smartsheet, there are a few options based on your preferences and context for this process.
Here are a couple of options:
1 - You could clear the existing completion status of the repeated tasks via automation. Perhaps clear a [Completion %] column or adjust a [Status] to "Not Started" via the Clear Cell Value and Change Cell Value workflows.
2 - You could build a sheet with these repeated tasks and then have a copy row automation that brings them into your overall webinar schedule each quarter.
Depending on how many events you're doing and their complexity, you could also use Control Center to build out these projects, but that's probably overkill.
Sam_Harwart