Best Of
Re: Deactivate form after set # of entries/submissions OR by date
I would love to have the ability to deactivate the form after a specific number of entries. We use forms for event management and have limited space. It would be extremely helpful if the form could be deactivated automatically after a certain number of entries.
jd4cu
Re: February Question of the Month - Join the conversation and receive a badge
I'd love to see a Smartsheet Mentor badge, with nominations similar to the Peak Human badge process.
ss_innovation
Re: Is there a way to generate an alert/block on Smartsheet, in case a schedule causes overallocation?
Hi Isaac, thank you so much for your detailed guide, I will try it!
hilalt
Re: Smartsheet User Groups - Sign Up Today!
Hi Angie! We're working on adding more virtual sessions to the calendarโstay tuned! We're also exploring future locations, possibly in Florida!
Kelsey Hayden
Re: Sheet Summary with combined date fields
If your dates are in date format columns you could try the DATEONLY function.
=DATEONLY([Start Date]#) + " - " + DATEONLY([End Date]#)
If they are text you can use the LEFT function to return only the first 8 characters.
=LEFT([Start Date]#, 8) + " - " + LEFT([End Date]#, 8)
KPH
Re: Data Shuttle: Missing Rows/Entries
This isn't a fix, more of a workaround but you can change your data shuttle to inly add and update, instead of add, update and delete so if the new data isn't there you just keep the old data and then when you turn on highlight changes you'll see which unique ID's didn't change and therefore don't have stats for that month
alyssad
Re: Report not updating formula unless the underlying sheet is opened and "refreshed"?
@James Keuning, I had a similar problem with the RGYB symbols not updating for reports unless the sheet had been opened. Although some users suggested adding a date to helper column and running an automation to update the date every night, this threw off my "Date of Last Activity" variable by making it look like every project had been opened every day.
@Ryan Sides (giving credit where credit is due) mentioned he had noticed toggling the Lock Row variable does not effect the auto populated "Last Modified On" column and suggested I try toggling the Lock/Unlock through a nightly workflow... it solved my problem wonderfully. No Helper sheet needed, no other dates getting interfered with, no changes to my sheets when it is completed.
Here's a screen grab with an example of the automation I now put into all my templates. Try it and see if it helps solve your TODAY() function issue... and please let us know!
Andrew Stills
Re: February Question of the Month - Join the conversation and receive a badge
Workflow Wizard - for those who assist other users in troubleshooting automation workflows.
JGrison
Re: Automations and sheets loaded with checkboxes...
Instead of any field changing, set your trigger to when a specific checkbox becomes checked.
Paul Newcome
Re: How to change auto number formula when value changes in a column
Hi @Julie Mary
I changed your sheet a bit as I don't know how to indent without inputting some date to name. (I input P, which is grayed out with the conditional formatting.)
I also added a [Parent Row] helper column, which shows the row number of the parent.
Then, I used the SUMIFS function as follows;
[Nr] =IF(NOT(isParent@row), SUMIFS(NameChange:NameChange, Row:Row, <=Row@row, [Parent Row]:[Parent Row], [Parent Row]@row))
[NameChange] =IF(NOT(isParent@row), IF(INDEX(Name:Name, MATCH(Row@row - 1, Row:Row, 0)) <> Name@row, 1, 0))
[Parent Row] =PARENT(Row@row)
