Best Of
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
Re: Create Report Summary, Similar to Sheet Summary
Agreed, this would be helpful. To expand on the idea, these Report Summary fields could be referenced during PDF export in the "Add note to header" field to allow for more dynamic control over issued text.
Kyle Chipman
Re: VLOOKUP on a Multi DropDown List
Hi @@Robert McKnight
Hope you are fine, i changed your current formula
=IFERROR(VLOOKUP(Barcode@row, {Current Hard Drive Requests Range 1}, 9, false), "")
with the following formula to solve the problem of pick more than one dropdown value.
=JOIN(COLLECT({Responsible Owner(s)}, {Loaned Drive}, CONTAINS(Barcode@row, @cell)))
please check the workspace you shared with me. and don't hesitate to call if you have more issues.
Bassam Khalil
Re: Combine Data from 2 sheets using one common column as a link.
We found out we need to use Brandfolder to allow for the metadata to link between the sheets.
Kevin7859