Best Of
Re: How to fix adding 1 or -1 to date difference calculations
Try this=NETWORKDAYS([Expected Delivery Date]@row, [Actual Delivery Date]@row) + IF([Expected Delivery Date]@row > [Actual Delivery Date]@row, 1, -1)
Re: Automatically Sort Rows in Sheets
@SSFeatures - according to Chrome this is not a free extension. Did I miss that being mentioned it the above post? If it's not there, I highly recommend that any cost be mentioned for transparency. I've never paid for a Chrome extension, and I don't have budget authority to do so.
Loann McGee
INTUIFACE API Intergration
Add compatibility for INTUIFACE user interface software to communicate with smartsheet via API on all platforms, inparticular IOS.
Allow requests from origins,
Player running on iOS, with the origin capacitor://localhost (capacitor://localhot)
If you were using Intuiface on the web, the origin would be
further assistance contact our team at support@intuiface.com INTUIFACE has shown willingness to work with SMARTSHEET.
Intuiface is fantastic software for creating custom user interfaces, to be able to interact with smartsheet the same way that it can with Excel would open so many opotunities.
CAnnon
Re: Copying action while building Automation
Similar request https://community.smartsheet.com/discussion/105426/automation-workflow-action-condition-drag-and-drop-copy-and-paste?_gl=11lztxdq_gcl_auMTI2ODY5MDkwMS4xNzQxODgyNDUy_gaMzQ4MDE5ODk5LjE3MzgwMjYyODg._ga_ZYH7XNXMZK*MTc0MjM1MTUzNS4xOS4xLjE3NDIzNTE3MjguNDMuMC4w
Eitan
Re: Copying action while building Automation
When making larger, and more detailed, automation workflows, it would be nice if they ability to either copy or move a Condition or Action box to another location.
Ryan W
Re: How to flag duplicate dates within a range
Putting this in a flag type column should do the trick:
=IF(COUNTIFS([Annual Leave Start Date]:[Annual Leave Start Date], @cell <= [Annual Leave End Date]@row, [Annual Leave End Date]:[Annual Leave End Date], @cell >= [Annual Leave Start Date]@row) > 1, 1)
Paul Newcome
Re: Deactivate all automation on a sheet
Would be nice as projects get closed, we could turn off all automations within the projects folder in one toggle than heading into each asset to deactivate.
Ma_boylan
User name display
Hi
I am adding new users to smartsheet but would prefer that their first and last names show and not just their email addresses.Β This happens even if I add them to my contacts?
Is there something that I am not doing correctly? which is not allowing the display of their names the way we want it.
Any assistance is appreciated.
thanks
Roshni Verappan
Re: Copying action while building Automation
<sigh> another basic capability that should have been available years ago
John Clifton
Re: Happy 10th Anniversary Community + Giveaway!
A big thank you to everyone who celebrated 10 years of Community with us, we appreciate having you all here making the Community a great place for all Smartsheet users.
Now, the moment we were all waiting for. We're ready to announce the winner of the giveaway. π
The grand winner of the Anniversary giveaway isβ¦ @Michelle Choate 2!! Congratulations Michelle! We'll be reaching out to make sure you get your prize. π€©
Thank you once again to everyone for celebrating this milestone together with us, and for sharing your responses to the prompt!
Rebeca S.