Best Of
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)
Re: Community Corner Newsletter [February 2025]
Every single line of this was worth reading. Welcoming all the new Community Champions.
Amit Wadhwani
Re: Dashboard PDF
Hi @Nixi
I hope you're well and safe!
It's in the pipeline!
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: Action : change cell value
Hi Bosen,
can you share more information on the main reason why you want to do so with a automation?
What's your final goal, overall?
There might be simpler way to do so.
Best
Davide
Re: Formatting issue with my rowID field, anyone notice anything like this before?
Ok, I like it. Picasso!
Thanks so much @KPH!!! I used the forward slash formula that you shared and this looks infinitely better than what I had before for these ROWIDs!!!
=Account@row + "- " + SUBSTITUTE([Story Category]@row, CHAR(10), "/") + " [Look " + [Look Number]@row + "]"
Matthew L
Re: Formatting issue with my rowID field, anyone notice anything like this before?
That is excellent. If you want to have all the options from the multiselect on one row you could replace the line break with a space (or something else) using the SUBSTITUTE function:
=Account@row + "- " + SUBSTITUTE([Story Category]@row, CHAR(10), " ") + " [Look " + [Look Number]@row + "]"
This would use a forward slash instead of the space - you can use anything you like.
=Account@row + "- " + SUBSTITUTE([Story Category]@row, CHAR(10), "/") + " [Look " + [Look Number]@row + "]"
KPH