Best Of
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
Re: Re: Document Builder - Generate 1 PDF Document w/ Multiple Rows
This cade is a game changer for a program I'm supporting! My sheet needed to calculate totals across various programs at different campuses. This then needed to be generated into a PDF.
In case it might save anyone else some head scratching, to identify the next child to copy over, you just change the final number
Child 1: =IF((COUNT(CHILDREN([Subcontractor Name]@row))) > 0, INDEX(CHILDREN([Subcontractor Name]@row), 1), "")
Child 2: =IF((COUNT(CHILDREN([Subcontractor Name]@row))) > 0, INDEX(CHILDREN([Subcontractor Name]@row), 2), "")
You can also change out the Index column's name to copy over data from a different column, change the Index column.
VictoriaD
Re: Unparsable formula; Sheet summary SUMIF formula
Hi @Bkb,
When a column has a space in the name, it needs to be enclosed in brackets when being referred to.
=SUMIF(Status:Status,"Quoted",[EST. GP]:[EST. GP])
Hope this helps,
Dave
DKazatsky2