Best Of
Re: Report - Recent Changes
Thank you. I can get by with utilizing the intro information contained to the row. However, if it is something that could be worked on, I would find it helpful if that primary column was its own column to aid in sorting and working with the Excel file of the log.
AmandaB
Re: How can I make an Second update request TRIGGER a workflow?
Yes, @Pascale
When APV Status is RQST2 DCL, the workflow will skip the First Approval Request and automatically jump to the second one.
In the workflow, the logic structure is;
Where APV Status is not one of REQSTQ DCS,
Request an approval (APVR1),
otherwise,
Request an approval (APVR2).
Re: Automate Workflow to Refresh 2 Sheets based on adding to another sheet
@Sherry Fox I've been finding that Chat GPT has some seriously solid insight on problems like this. I'm clever, but it would have taken me a day of testing to come up with a solution for this issue. Glad it worked out!
Lucas Rayala
Re: I'd like to create a column formula that references a specific cell with acceptable syntax
@jcabaniss , swap out this:
=[Target End Date]1
with this:
=Index([Target End Date]:[Target End Date], 1)
the second value in an index function is the row—usually we make this a MATCH lookup function but it can also be a number.
Lucas Rayala
Re: Can you have a URL open in a different tab when linked in a Form?
Hello, I had the same issue but identified that if you right-click on the hyperlink, you can select to open in a new tab.
I added this wording (in header format) to the top of the form.
I hope this helps.
BTomei
Re: INDEX/MATCH/COLLECT How to get most recent entry by person and by most recent date
Sorry, I’m having trouble writing my last comment and I realized you were asking for the most recent, and I gave you the formula for the earliest. Do what I said in the first post but but update this formula as follows (just change the greater than symbol to less than):
=IF(COUNTIFS(Item:Item, Item@row, RowID:RowID, <=RowID@row)=1,"x","")
Lucas Rayala
Re: Attaching the same documents to every row in a sheet
Excellent! Thanks for the update!
Also, sometimes I have to save the draft before I can post. Maybe related? ¯\_(ツ)_/¯
Andrée Starå
Re: Calculating Avg Workdays w/ Conditions
Your "if" statement is not correctly stated.
Use a Collect to agglomerate data that you want to calculate.
=AVG(Collect([what you want to average], Critera range1, Critera1, criteria range 2, criteria2, ... etc
=AVG(COLLECT({AVG WDAY},{Request Type},="FIOA",{PLU Assigned},="Bridgett Fenner"))
Christian G.
Re: Creating an "On-Hold" status for projects in Resource Management?
Hey @NickSeier
There currently isn't a way to set a custom Project Type in Resource Management for "On Hold" - please feel free to create a new Product Idea in this topic, here!
You could potentially leverage the project tag feature to add context, here's more information: Add Project or People Tags
Cheers,
Genevieve
Genevieve P.
Re: Automated Project Phases in Resource Management?
I have the same issue. I was thinking an additional column to specify the name of a phase that should be allocated in Resource Management.
I see there is an idea in the Feedback and Ideas section: Tasks from Smarsheet should be syncable to Phases created in RM, or at least movable to them — Smartsheet Community
Seems to be on the same track.
rshiers