Best Of
Re: February Question of the Month - Join the conversation and receive a badge
As a kid I wanted to be an interior designer and be around people...ALWAYS!! Now I work in Project Controls, remotely (rarely speaking to people thought the day). 🤣
The older I got, the less I wanted to spend time with people 😎
jacquedale
Re: Post Badges to LinkedIn
I think this is a great idea! Would be nice to show accomplishments and learnings from Smartsheet, over on LinkedIn.
Lauren.Traub
Re: Is there a way to count the number of attachments in a row?
HI @Xochitl C.,
This is not currently possible, but it is a great idea. Please submit an enhancement request for this if you would like.
Thanks,
John
John_Foster
Re: Report sharing
I don't remember hearing about anything like that, but if you just need to share somebody as viewer access, a workaround is to embed said report onto a dashboard, then share the user to that dashboard as a viewer. They can then access the data without having access to the sheet.
If the user needs to input data for the report, you could set up sheet automations for update requests (or send manual updates).
If you want to give them full access to a report, then Smartsheet has a couple premium apps in Dynamic View and WorkApps that you can share somebody to a report with full access to edit/attachments/comments without accessing the source sheet.
Jason Tarpinian
Re: Why dont non working days carry thru to other projects?
If you've set working days for your organization at the account level, this will only apply to newly created sheets moving forward, unless they were created through a Template. Sheets from a template will inherit the Template settings.
Here's more information: Working days, non-working days, and holidays at the account level
Cheers,
Genevieve
Genevieve P.
Re: Group WorkSpaces and organize them in "folders"
I'm currently facing the same challenge. My only hack is using a unique acronym for the beginning of each workspace title. All "archived" ones start with ZZ to push them to the bottom of the list. I have workspaces for each member of my team, and these all start with "RM"(Recruiting Manager) and then the person's name. This way things are at least together on the list.
This is the main reason I held off on using workspaces. But as my projects got larger, it became too tedious to share. I would have had to share every item in the team member's folder individually, vs having a workspace that I share all at once.
I have found workspaces to be phenomenal in a multitude of ways, but as I use and create more of them the list has become increasing long and difficult to sort through.
Erica Cole
Re: Three criteria SUMIFS
Continued from above
3 Adding in dates to the SUMIFS
You need to follow the pattern of range to look in, thing to look for, range to look in, thing to look for. AND is assumed in all SUMIFS. The result will be where all the parts are true.
So, to add your requirement for starts on or after you would add this part in bold. Note the is only one parenthesis between DATE and 2024.
=SUMIFS({Time}, {Location}, [Location2]@row, {Date}, @cell >= DATE(2024, 1, 1))
And then to add an end date you need to repeat the pair:
=SUMIFS({Time}, {Location}, [Location2]@row, {Date}, @cell >= DATE(2024, 1, 1), {Date}, @cell <= DATE(2024, 1, 31))
So now this:
Gives us this:
4 And finally
I noticed a little "Month" column on your sheet. I would love to include that in the formula so that you can change that one cell with "January" in it and update all your formulas without doing anything to the start and end dates.
Let me know if you are interested.
KPH
Re: DataMesh & Locked columns
It will depend on who built the Data Mesh workflow.
- If the user who created/runs the workflow is an Admin or Owner, any locked columns/rows will updated.
- If the user who created/runs the workflow is only an Editor, then no, the locked row won't update.
Data Mesh is an automated substitute for the shared collaborator and takes on their permitted actions. Whatever they can do on the sheet, the workflow can do. Whatever they're restricted by, the workflow is restricted by. Does that make sense?
Genevieve P.
Re: February Question of the Month - Join the conversation and receive a badge
When I was a kid - I wanted to be a veterinarian or doctor... organic chemistry put paid to that dream!! Ended up with an Economics degree and an interesting and varied career in banking and start ups - a nice long gap to raise a family - and finally as a PM in a group insurance company. Most proud of my kids for sure!
Dixie Morse
Re: Is there a way to adjust row height?
It's hard to believe that it's now September 2023, and this simple feature is still not available.
DianaR