Best Of
Re: Displaying dashboard data based on drop-down selection
Hello @Simon Cowx
As far as I know, this is not an option currently available.
What I did was create a cluster dashboard with images which link to each separate project in an elegant way. It's not a drop-down, but it's another efficient option for getting people where they need to be.
Hope this helps
SteyJ
Re: Formulas referencing too many cells on source or destination sheet 👎
That limit isn't strictly relegated to cross sheet references (blue or black arrows). If I have a column formula referencing a column in the same sheet [Column Name]:[Column Name], that counts towards that limit as well.
@Genevieve P. I remember we recently had a discussion on another thread where you were able to provide some really good insight into the cells being referenced limitations, but I can't seem to find it again. Would you happen to have a link handy?
Paul Newcome
Re: Dynamic View Comments notifications for user without access to source sheet
I am also interested in a resolution for that; because without it, it kind of makes the whole dynamic view counterproductive.
Thank you
Chloe H
Re: Add Months to Date formula?
You are missing a closing parenthesis on the first line - ISDATE([Payment Start Date]@row, - and you have an extra closing parenthesis at the very end. This should fix it:
=IF(AND(ISDATE([Payment Start Date]@row), ISNUMBER([Payment Term Months]@row)), DATE(YEAR([Payment Start Date]@row) + FLOOR((MONTH([Payment Start Date]@row)) / 12, 1), MOD(MONTH([Payment Start Date]@row) + [Payment Term Months]@row, 12), DAY([Payment Start Date]@row)), "")
Carson Penticuff
Re: Does anyone have a trick to remove sharing of multiple users on multiple sheets?
A little tip for the API... Drop them all in the same workspace if you can. Then you can just run the API on any sheets within that workspace using the workspace ID. You should also be able to set the API up to run whenever a new sheet is added. This way you can add them a few at a time if they are spread out and even keep this solution for future use.
Did you submit the enhancement request through the form or through the Product Ideas tab at the top of this page? If through the Product Ideas tab, feel free to share the link to the idea here so others can add their votes if they stumble across this thread looking for the same thing.
Paul Newcome
Re: Help with Dates not spanning over days that are not being used.
Next month (on a rolling basis) would be
=IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1), DATE(YEAR(TODAY()) + 1, 1, 1)) - 1
I also have an EDATE solution that works with either a negative or positive number of months that could be used similarly. It too uses an IFERROR(DATE(), DATE()) combo, so it would be a matter of referencing the number of months column and then adding 1 to it to get the last day of the month output by the EDATE solution (or a helper column that just adds 1 to the number of months and reference that instead of the "display" number of months).
Paul Newcome
Re: Cross Project Dependencies
Hi @PattiL
Currently in Smartsheet dependencies and predecessors are specific to each sheet and cannot be linked across multiple sheets. (Please submit your feedback about this to the Product team, here!)
However you could potentially create your fourth sheet, then use a Report to bring together the specific critical tasks from all four sheets, Sorting the Report by the Start Date and looking at it in a Gantt view. Although the tasks wouldn't be directly linked or able to automatically adjust across sheets, this would offer you a condensed view across all your projects. I hope that helps!
Cheers,
Genevieve
Genevieve P.
Re: Issues with DDUpdate?
Hi, our last payment went through successfully on 15th August and we haven't noticed any issues with DDUpdate functioning.
Emmet McKenna
Re: Symbol Flexibility - more symbol colors/options
A more creative workaround might be a creating your own flag with particular words like B Y G Gr Bl, etc. and then using conditional formating to color the cell based on the word or letter combos in the cell. Have you thought about that?
Mike Wilday
Re: Count the number of rows where a column (multi select dropdown) has more than one value
Hi @latheobald89201,
This should work:
=COUNTIF({Attendee Role}, COUNTM(@cell) >= 2)
Hope this helps, but if you have any problems then post what they are! 😊
Nick Korna