Best Of
Re: When will resources for self-studies be available (and other questions)? (Pro Learning path)
Keeping up with all the certifications can be challenging. To be honest though, I've gained the most knowledge from right here in the Community Forums. Sometimes I'll read someone's issue and work through how I would solve it. If I'm not too sure that's the best way then I bookmark the post and wait for someone else to reply and see how their response compares to how I would've solved it. You can learn so much about how the tool functions in real world environments here in the Forums.
I know its not the answer you were looking for, but I hope it helps in some way.
Matt
Matt Johnson
Re: Changing Seat Type to Guest
FYI here is our business case submitted to Product Ideas. @Estelle Redding
tim.wimmer49936
Re: INDEX/MATCH Most Recent Entry
If the new entries are by form, you could also set the form to put new entries at the top of the sheet and use the standard INDEX/MATCH.
Another option if you have multiple rows for the same project with the same date / time stamp (and new rows at the bottom) would be to use the INDEX/COLLECT to collect all rows for the Project Name, then a COUNTIFS for the "row number" portion of the INDEX.
=INDEX(COLLECT({Percentage Complete}, {Project Name}, @cell = [Project Name]@row), COUNTIFS({Project Name}, @cell = [Project Name]@row))
Paul Newcome
Re: INDEX/MATCH Most Recent Entry
Hi @John Loushin,
See if this works for you.
=INDEX(COLLECT({PERCENTAGE COMPLETE}, {PROJECT NAME}, [Project Name]@row , {CREATED}, MAX(COLLECT({CREATED}, {PROJECT NAME}, [Project Name]@row ))), 1)
Hope this helps,
Dave
DKazatsky2
Re: Changing Seat Type to Guest
Correct. We have been on it since 2018 and now we are actively working to transfer processes to other systems. The one and only chance that we would continue is if they give back control of user creation and asset creation to Admins. The provisional user model is ridiculous. Even if we did renew next time, it would be a much smaller footprint as we are actively moving things out. There are certain departments in the company that would never use it again.
tim.wimmer49936
Re: Dynamic dropdowns - Waterfall request
This would be huge for us. We would also like to be able to populate dropdowns via reference sheets so we don't have to edit them every time a job title is added or a department head changes.
Sara Campbell
Re: Dynamic dropdowns - Waterfall request
It would be great if we could setup the ability for conditional dropdown lists / feilds directly in smartsheet without workarounds in forms/etc.
John D'Angelo
Re: Dynamic dropdowns - Waterfall request
Make a conditional dropdown list that dynamically responded to values of other cells
bjt0022
Re: Why is % Complete not the same between Smartsheet and Microsoft Projects
@Katie White - thank you!! That article makes so much sense (or at least makes the issue clearer) - I don't use Gantt view much, so I haven't seen that setting. @Aubrey Ferreira , my apologies for misunderstanding; and hope you both have a great rest of the week!
jjg279
Re: I am an Admin, but I cannot edit the workspace
Its not a bug, this is the behaviour from the new User Subscription licensing model. A System Admin on your plan has downgraded your share to this sheet to that of a Viewer. You will need to contact your system admin person within your organisation for them to restore your permissions, but they will have to buy/allocate you a license (now called a Seat) to do it.
Debbie Sawyer