Best Of
Re: Link Report in Form
@ejacksonBPT You can use a Heading / Description Field and hyperlink text to share the publish link to the form, or the url, if everyone that needs that space will have the report shared to them.
This will launch the hyperlinked report in a new window.
Re: Meet Julia L Rumburg, our February Member Spotlight! π
Well deserved for an awesome teammate!
DanMorales
Re: Meet Julia L Rumburg, our February Member Spotlight! π
What an amazing spotlight for an equally amazing person, PeerConnect and Friend! Congratulations @Julia L Rumburg
Protonsponge
Re: Zapier automation no longer working with Smartsheet (all of a sudden)
Hi @Clinton W,
That does seem like strange behaviour. Iβd recommend posting your question in the Smartsheet API Community. If youβre still unable to reach a resolution, Iβd then reach out to our Support team so that they can investigate what might be causing this issue.Β
Thanks,Β
Georgie
Georgie
Re: Square Radio Buttons?
The square buttons indicate that's a drop-down type column with multi-select available. Circle buttons are single-select only.
Jason Tarpinian
Re: How to return lowest date when index matching complete columns rather than just a selection?
Hello @D Rowland
I think a MIN(COLLECT formula could be useful for you to return the earliest date for each [SO Number]. I have made a quick demo using the formula below.
The formula will return the earliest date from [Finished Date] where the SO number in the Data Sheet matches the [SO Number]@row in the look up/formula sheet.
=MIN(COLLECT({Data Sheet_Finished Date}, {Data Sheet_SO Number}, [SO Number]@row))
Data Sheet:
Look Up/Formula Sheet:
I hope that is helpful to you in some way,
Protonsponge
Protonsponge
Re: Conditional Formatting or Automation For Time
@AKalsi Does this video on using the Time() function help you any?
Darren Mullen
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet: Like if Excel and ChatGPT went on a tech adventure together!
Kate C.
Re: Conditional Formatting or Automation For Time
@Darren Mullen Thank you so much, that was exactly what I needed. Between that video and the one that played right after, I got what I needed. I pasted a link to the second video I was referencing. This was a big help!
Smartsheet Date Time Calculations: Calculating the Difference Between 2 Dates and Times
AKalsi
