Best Of
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a web-based work management platform that lets me organize, automate, and visually communicate the work of my team.
:)
And is also my favorite tool ever!
Jennifer Kurtz
Re: Trouble with IF statement and date format conversion
Happy to help. ποΈ
That formula in your last comment is accounting for moving from December to January using the IFERROR.
=IFERROR(DATE(yyyy, mm + 1, 1), DATE(yyyy, 1, 1))
Paul Newcome
Re: How do I write a formula to use multiple columns in a single cross-sheet reference.
Depending on what you are trying to pull off, this may be straightforward or may be an absolute nightmare. Certainly you can make a cross sheet reference to more than one column - figuring out how to use it in a formula is a bit trickier. With no direct equivalent to the "offset()" function in excel, the two methods I've seen used are vlookup() and index({inputRange},match(),match()) with the input range being multiple columns in a single reference. Both have weaknesses and ways they can go wrong, but are paths that might work for you. More specific advice would require more specific levels of details.
Jgorsich
Re: Help with COUNTIFS function
Hi Eric,
To set up the formula in another sheet it would look something like the below equation:
=COUNTIFS({Range Related Product},"Envarsus",{Range Qtr Due}, "Q1 FY25")
This formula would give the count of all rows that have Envarsus in the Related Product column and Q1 FY25 in the Qtr Due column. When you're in the other sheet entering the column reference, choose Reference Another Sheet and then navigate to this sheet and choose the appropriate column.
If the two columns you're using in the Count Ifs function are not dropdowns that have standardized entries but instead might have the text you're looking for you could do this:
=COUNTIFS({Range Related Product},CONTAINS("Envarsus",@cell),{Range Qtr Due}, CONTAINS("Q1 FY25",@cell))
Hope this helps!
Elska19
Re: See a form and not spreadsheet
I forgot to update the ticket on Friday.
Yes! The form does open as it should
cswicegood
To the Incredible women in the Smartsheet Community
To the incredible women in the Smartsheet Community and all women around the world.
Not just today on International Women's Day, but every day β thank you for your hard work, strength, and dedication.
While we may not always express it as well as we should, know that we respect, admire, and appreciate all that you do.
I have the privilege of working alongside talented, inspiring women who lead, support, and make a difference every single day. If I could embody even half of their dedication and excellence, I would consider myself fortunate.
So today, and every day, thank you for making our Smartsheet Community, and the world, a better place.
Protonsponge
Protonsponge
How to set up Data Shuttle offload to create a new file (with date for example) each time it runs?
I'd like to offload a Smarsheet to a Sharepoint location as an excel file, but would like it to be done monthly and to generate a new excel file (not update an existing one) each time this happens with the name of the file containing the date for example. Is this possible? Can this functionality be built in somehow?
Jangir
Re: Formula Order of Operations Problem
Smartsheet AI Generated a successful formula⦠Thank you to Smartsheet AI⦠I will leave the post in case it would be helpful to others!
=JOIN(COLLECT([Class C Pant Issuance]@row:[Jacket Issuance]@row, [Class C Pant Issuance]@row:[Jacket Issuance]@row, NOT(ISBLANK(@cell ))), CHAR(10))
Michelle Rogers
Re: Calculate totals across multiple project sheets , using another sheet to get the list of projects
We have utilized reports to address items like this in the past, and then run the counts off the report. Since the report will auto update and collect the new information, it is a one and done formula.
The criteria you are using for example does not equal complete, can be addressed with filters.
Then you can group by team member and add summaries to get active counts for each.
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet's helps simplify Project Management for Stakeholders and Sponsors.
Lenny