Best Of
Freelance Work Wanted~!
Hi there! I’m a Project Manager & Smartsheet Specialist with over 5 years of experience helping teams streamline workflows, build insightful dashboards, and automate tedious tasks. I genuinely love making people’s work easier, more efficient, and more impactful—because when your systems work for you, you can focus on what truly matters.
✅ Custom Dashboards & Reports for real-time insights
✅ Automations to reduce manual work and increase efficiency
✅ Project & Task Management Solutions tailored to your needs
✅ No project is too small—I’m happy to help however I can!
I’m looking for extra work to support my family while doing what I love—helping people succeed.
📩 Send me a message, and let’s build something great together.
Paul Woodward
PJWoodward12@gmail.com
Paul.Woodward
Re: Workapps Permissions and Collaboration
Multiple admins for Workapps would be awesome - highly recommend putting an enhancement request in if it's not already there
Brian_Richardson
Re: Can't create an X-axis on a scatter plot
Here is my solution.
In the sheet, the yellow columns are the original ones and the green columns are the newly added ones
ID : Text number column, prepopulated as much as you want.
Design Hours2. : is a distinct and sorted column of the Design Hours2 column in the yellow zone, with a column formula:=IFERROR(SMALL(DISTINCT(COLLECT([Design Hours2]:[Design Hours2], [Design Hours2]:[Design Hours2], <>"")), ID@row), "")
Scatter Unstarted. : column formula: =IFERROR(INDEX(COLLECT([Scatter Unstarted]:[Scatter Unstarted], [Scatter Unstarted]:[Scatter Unstarted], @cell <> ""), MATCH([Design Hours2.]@row, COLLECT([Design Hours2]:[Design Hours2], [Scatter Unstarted]:[Scatter Unstarted], @cell <> ""), 0)), "")
Scatter In Process. : column formula=IFERROR(INDEX(COLLECT([Scatter In Process]:[Scatter In Process], [Scatter In Process]:[Scatter In Process], @cell <> ""), MATCH([Design Hours2.]@row, COLLECT([Design Hours2]:[Design Hours2], [Scatter In Process]:[Scatter In Process], @cell <> ""), 0)), "")
Scatter Completed. : column formula=IFERROR(INDEX(COLLECT([Scatter Completed]:[Scatter Completed], [Scatter Completed]:[Scatter Completed], @cell <> ""), MATCH([Design Hours2.]@row, COLLECT([Design Hours2]:[Design Hours2], [Scatter Completed]:[Scatter Completed], @cell <> ""), 0)), "")
I hope it helps!
Gia Thinh
Re: February Question of the Month - Join the conversation and receive a badge
I'm not very creative but some ideas I have are badges for community ranks and creating and using templates.
khickman
Re: February Question of the Month - Join the conversation and receive a badge
"helping hand" badge for folks who are quick to share skills
abbyc.hg
Re: Trying to get a list of distinct values across multiple columns based on multiple criteria
Hi @Jpress,
That’s right, you can’t use absolute references such as $1 in column formulas. You could drag-fill the WBS target value down to all existing rows and then autofill will automatically populate new rows.
However, my suggestion would be to create a sheet summary field and have users enter the WBS Target Value there, then reference that field in the formulas.
Your formula would then be:
- =IFERROR(INDEX(DISTINCT(COLLECT([Year 1]:[Year 1], [Year 1]:[Year 1], @cell <> "", [WBS - Text]:[WBS - Text], CONTAINS([WBS Target]#, @cell))), Helper@row), "")
You’ll then be able to delete the WBS Target Value column from the sheet, since we have now moved the value to the sheet summary field. Your sheet should then look something like this:
Does that work for you?
Georgie
Georgie
Re: Trying to get a list of distinct values across multiple columns based on multiple criteria
Hey @Jpress,
We can do that by adding in the CONTAINS function to the formulas in the Year 1 Distinct to Year 4 Distinct columns. However, we’ll need one more helper column to convert the WBS value to text, as CONTAINS does not work with numbers, only text strings (I used Paul’s comment here to help with this one - thanks @Paul Newcome!
So, next steps are as follows:
- Create a helper column named “WBS - Text”.
- In the "WBS - Text" column, use the formula =WBS@row + “” and convert to column formula.
- Edit the existing formulas in the Year 1 Distinct to Year 4 Distinct columns so that they follow this base formula (I’ve made the section that’s changed bold so you can copy and paste this into the relevant spot in all 4 formulas):
- =IFERROR(INDEX(DISTINCT(COLLECT([Year 1]:[Year 1], [Year 1]:[Year 1], @cell <> "", [WBS - Text]:[WBS - Text], CONTAINS("123", @cell))), Helper@row), "")
- Hide the “WBS - Text” column and re-hide the Year 1 Distinct to Year 4 Distinct columns.
That should do it - let me know!
Georgie
Georgie
Re: Formula Issue
See below, i added in the beginning an IF statement to check for a date, then i also changed your formula to make it a bit smaller by adding the year at the end only one time…
=IF(ISDATE([CLEAR Approval Date]@row), IF(MONTH([CLEAR Approval Date]@row) = 1, "Jan-", IF(MONTH([CLEAR Approval Date]@row) = 2, "Feb-", IF(MONTH([CLEAR Approval Date]@row) = 3, "Mar-", IF(MONTH([CLEAR Approval Date]@row) = 4, "Apr-", IF(MONTH([CLEAR Approval Date]@row) = 5, "May-", IF(MONTH([CLEAR Approval Date]@row) = 6, "Jun-", IF(MONTH([CLEAR Approval Date]@row) = 7, "Jul-", IF(MONTH([CLEAR Approval Date]@row) = 8, "Aug-", IF(MONTH([CLEAR Approval Date]@row) = 9, "Sep-", IF(MONTH([CLEAR Approval Date]@row) = 10, "Oct-", IF(MONTH([CLEAR Approval Date]@row) = 11, "Nov-", IF(MONTH([CLEAR Approval Date]@row) = 12, "Dec-", "")))))))))))) + RIGHT(YEAR([CLEAR Approval Date]@row), 2), "")
Leibel S
Re: Creative Project Management - Help Streamline
Hi @Erin Horiuchi Green - thanks for responding. I didn't see a request come through. Can you request again?
lm56