Best Of
Re: Filter Help
It appears that you're attempting to house a table within the sheet (different columns for different groups of rows). I do not believe that you will be able to accomplish that. If you adjust your data to not have "stacked" tables within the sheet, you will be able to filter using @Jeremy C 's instructions.
adp_cl
Re: why when I remove a person at a sheet level is their permissions removed from the workspace level?
It sounds like you were an Admin of the Workspace and your colleague was the Owner, is that correct?
An Admin can make themselves the workspace owner by removing the current workspace owner. This is the only way to change ownership of a workspace. (SeeΒ Transfer Ownership of a Workspace).
When you're looking at a user shared to a sheet, if the sheet is in a workspace and the sharing window is showing you their workspace sharing permissions, you'll see a different icon next to their name:
In this instance, Mark is shared to the Workspace level as Admin (indicated by the blue Workspace icon). On the other hand, Antonie is shared just to the Sheet.
When you hover over the "x" that appears next to their name, a helper box will pop up letting you know if you'll be removing that person from the Workspace or just the sheet.
Keep in mind that you can share one person at both the workspace level and at a sheet level. For example, maybe I wanted to give Antonie Viewer permissions of the entire workspace, but on this one specific sheet I want him to have Editor permissions. In this case I would share him twice, and he would appear in the Sharing window twice.
Let me know if I can help clarify anything further!
Cheers,
Genevieve
Genevieve P.
Re: Using INDEX/COLLECT to return multiple values
Hey @RaffyM
The number order in your helper column won't matter, as long as you have 1 - 600 (or however many) listed as unique numbers in that column.
If you'd prefer to keep your sheet sorted with 1 - 600 in your Number Helper in order, then what you would do is create a Row Report off of this sheet:
- The Row Report would use this second sheet with the formulas as the Source.
- You would then filter by if the Rank is less than 21.
- Once you have the filtered rows in your Report, you can then sort the Report by the Rank column.
Sheets don't currently auto-sort, but the Report will! Here's a webinar on building a report: SmartStart: Reporting
Happy Friday to you as well π
Genevieve P.
Re: Character Limit on Emailed Notifications
Hi A.J,
It seems your email body exceeds 2000 character limit. This leads to "message truncated due to length" warning.
Try to create a helper column "Count" in your sheet to count the characters of all field you want to add in the workflow. Then in the workflow, you will check the condition : If Count < 2000 then send all fields, else send fields in 2 seperate emails.
Hope this works for you.
Gia Thinh
Re: Aderant integrations
Since Smartsheet doesn't have a direct integration with Aderant, you could potentially use a third party application (similar to Zapier) or the Smartsheet API.
You may want to reach out to Aderant Support regarding what's required for integration from their side.
Cheers,
Genevieve
Genevieve P.
Re: Help with Formula to Capture Dates for Full 12 Months
Make 3 helper columns that simplify your formula:
- Start Year: =YEAR([Start Date]@row)
- Start Month =MONTH([Start Date]@row)
- Start Day =DAY([Start Date]@row)
then your formula for each of the months is the below, replacing the bolded numbers with the corresponding month (e.g. April would be 4)
=DATE(IF([Start Month]@row > 1, [Start Year]@row + 1, [Start Year]@row), 1, [Start Day]@row)
Leibel S
Re: Celebrating the Community with Smartsheet Swag!
Hello all, that link that was shared to the merch store earlier in this thread is internal and for Smartsheet employees only. Sorry for the confusion, though we of course think of our members as part of the SMAR fam! Good news is that we have plenty of swag plans coming on Community, including this one for Seekers, Contributors and Counselors. Get your forms in, and more to come. π
Alison C.
Re: Is there an easy way to build a report with same order of columns.
This sounds like it would be a great item to submit to the Product Idea page on the Community. Iβve also created many Reports, and like yourself, often struggle when the list of columns is sorted alphabetically instead of the way Iβve intentionally ordered them in a sheet. I donβt think thereβs a workaround for us (other than pulling up the underlying sheet on one monitor and building your report on another, which still requires you choose the lesser of the two evils you describe in your original post).
Lauren Dominique
Re: RYG Formula and Status Question - almost there
Hi @johnna.young,
I think this will do what you're after:
=IF(Status@row = "Complete", "Gray", IF(AND(OR(Status@row = "At Risk", Status@row = "In Progress"), [Target End Date]@row >= TODAY(15)), "Green", IF(AND(OR(Status@row = "At Risk", Status@row = "In Progress"), [Target End Date]@row >= TODAY(4)), "Yellow", IF(AND(OR(Status@row = "At Risk", Status@row = "In Progress"), [Target End Date]@row <= TODAY(3)), "Red", ""))))
Sample:
The only thing it doesn't cope too well with is if you have an At Risk/In Progress status with no target end date - these will show up as Red.
Hope this helps, if you've any problems/questions then just post! π
Nick Korna
Re: NEW! Multi-widget editing in dashboards
To confirm, an example would be I can update all my header fonts at the same time? π€
Amanda Winter