Best Of
Re: syncing data between two sheets
Wonderful! I'm glad we were able to get there in the end. 🙂
Genevieve P.
Re: Introducing the newest Community Champions! 🏆 [January 2025]
Welcome new Champions! So exciting to have you heroes in the mix!! Get the word out, we bout to nerd out!! 🤓☑️⚡️⚡️💥
Will Jeffords
Re: If statement for if a due date is next month
=IF(ISBLANK([Due date]@row), " ",
IF([Due date]@row < TODAY(), "Late",
IF([Due date]@row = TODAY(), "Today",
IF([Due date]@row < TODAY(5), "This Week",
IF(AND(MONTH([Due date]@row) = MONTH(TODAY()), YEAR([Due date]@row) = YEAR(TODAY())), "This Month",
IF(AND(MONTH([Due date]@row) = MONTH(TODAY() + 30), YEAR([Due date]@row) = YEAR(TODAY() + 30)), "Next Month",
"Future")))))))
This hard codes in the +30. Give it a try and see if it helps.
Stephen McDaniel
Re: Conditional Formatting Issue for column formula
Just a couple of quick things to check!
1/ Is the format of the RM % column set to %? If it's Text/Number and showing 40% (vs 0.4) you'll want to correct this.
2/ If your test data is 55% or 110%, you won't see any formatting - change the green to "less than 0.56" and red to "greater than 1.09". This way, you're capturing all the values.
L J
Re: Dynamic View- using multiple contact columns to restrict access
@Halina W You are correct that that option only appears when referencing a sheet, but the Dynamic View will automatically pull the appropriate rows from the report based on who is viewing it. When referencing the report, there is no need to try to select a separate filter because the DV automatically inherits the filter(s) built in to the report.
Paul Newcome
Re: Introducing the newest Community Champions! 🏆 [January 2025]
Congratulations, Community Champions! I am looking forward to meeting as many of you as possible at ENGAGE 2025! I already recognize so many names from the community, so it is wonderful to see it official for you all!
Deena Duran
Re: Introducing the newest Community Champions! 🏆 [January 2025]
Congratulations to our newest Community Champions!
Neat picture you made there, @Protonsponge!
Ray Lindstrom
Re: Introducing the newest Community Champions! 🏆 [January 2025]
Congratulations to all our newest Community Champions!
Peggy Parchert
Re: Can I see all of my comments across sheets and reports in one place?
Awesome! I've upvoted it!
If you don't mind, please mark my response as being the Answer as it will help others find answers when they're searching.
All the best,
-Ray
Ray Lindstrom
Re: Smartsheet (Sharing folders to another user)
Hello @Christina Farrell,
You can only share at the file level in your Sheets section. You cannot share a folder of files from your Sheets section.
You can however turn create a Workspace, move your items to it, and share the Workspace with people. You can also still share the files individually to people you don't need having access to the entire workspace.
BRgds,
-Ray
Ray Lindstrom