Best Of
Re: Forms and entries
Great question! This gets asked a lot. Unfortunately a user cannot return to a form. Not for editing their previous entry, nor can they save half way through and return to complete it.
There are Product Ideas regarding this that you can upvote to help gain attention by Smartsheet's development team.
All the best,
-Ray
Ray Lindstrom
Re: Countifs in multi contact column referencing another sheet - Help!!
This seems to be working perfectly, thank you! I shall double check a few totals just to be sure but fingers crossed! Thanks so much.
NHS Cornwall
Re: Countifs in multi contact column referencing another sheet - Help!!
Give this a try:
=COUNTIFS({Archive T&F Date}, <=TODAY(), {Archive T&F Date}, >=TODAY(-365), {Archive T&F Presenter}, HAS(@cell, "Jen McFarland"))
Carson Penticuff
Re: Why has my Core App Skills badge not shown up on my profile?
Glad you got all squared away. Yes, there can be a delay on the badge appearing.
And yes, I am certified in both Core Product and Project Management.
I love using Smartsheet too! The company I work for is also the first company I've ever used Smartsheet with too. I had never even heard of it before working here.
If you don't mind, kindly mark my answer as "Answer", so other can more easily find answers. Thanks!
BRgds,
-Ray
Ray Lindstrom
Re: Help with INDEX/COLLECT with a MAX/COLLECT
Ok. Try this:
=INDEX(COLLECT({IA Assigned}, {RTO Queue ID}, [RTO Queue ID]@row, {Fully Executed Date}, OR(@cell = "", @cell = MAX(COLLECT({Fully Executed Date}, {RTO Queue ID}, [RTO Queue ID]@row)))), 1)
Paul Newcome
Re: Combo a vlookup/index formula to pull a value from one sheet with cond formatting to another sheet?
Hey @ParkerLeigh
Yes, it is possible however it will need a helper column on your Project Plan sheet to accomplish. A checkbox column will work.
The helper column formula will do the actual comparison between your current rate and min rate. Set your conditional formatting to highlight if the helper column cell is checked.
=IF([Bill Rate]@row < INDEX({Min Rate sheet Minimum Rate column},MATCH([Employee Name]@row,{Min Rate sheet Employee Name column},0)),1)
Remember since the formula contains cross-sheet references you will need to manually create the references - you cannot simply copy paste the formula.
Will this work for you? Shout out if you have any trouble
Kelly
Kelly Moore
Re: Formula Multiple Parameters with Multi-Sheet Reference
Thank you so much, this worked! To show the final version, the completed formula is:
=COUNTIFS({Sheet A Report Type}, OR(@cell = "Report Type 1", @cell = "Report Type 1"), {Sheet A Due Date}, AND(IFERROR(MONTH(@cell ), 0) = 1, IFERROR(YEAR(@cell ), 0) = 2025), {Sheet A Date Difference}, <2) + COUNTIFS({Sheet B Report Type}, OR(@cell ), {Sheet B Due Date}, AND(IFERROR(MONTH(@cell ), 0) = 1, IFERROR(YEAR(@cell ), 0) = 2025), {Sheet B Date Difference}, <2)
Susan Zimmerman
Re: Assign a Program Code, without using Auto Number
In order to see what the program code is for a program, rather than leave it blank, my inclination would be to set-up a separate master data sheet that captures all unique programs, and assigns them a code with an auto-number. Then, the Program Code can pull in via a cell reference based on the value in the Program Name field (dropdown). Just a thought for consideration.
L J
Re: Index/Collect Two Separate Dates and Compare Them to Return Highest Date
It may not be the most elegant solution, but this will just compare the output of the two different formulas you posted and use the one with the latest date.
=IF(INDEX(COLLECT({Date_Engagement}, {Type1_Engagement}, 1, {ClientName_Engagement}, [ClientName]@row), 1) > INDEX(COLLECT({Date_Engagement}, {Type2_Engagement}, 1, {ClientName_Engagement}, [ClientName@row), 1),INDEX(COLLECT({Date_Engagement}, {Type1_Engagement}, 1, {ClientName_Engagement}, [ClientName]@row), 1), INDEX(COLLECT({Date_Engagement}, {Type2_Engagement}, 1, {ClientName_Engagement}, [ClientName@row), 1))
Carson Penticuff
Re: How to add varying months to varying dates?
I see what happened here:
the below should fix it
=DATE(YEAR([Date Contract Executed]@row) + ROUNDDOWN(([Months Until Expiration]@row + MONTH([Date Contract Executed]@row)) / 12.00001, 0), ROUNDUP(MOD([Months Until Expiration]@row + MONTH([Date Contract Executed]@row), 12.00001), 0), DAY([Date Contract Executed]@row))
Leibel S