Best Of
Re: Conditional formatting change status with colors
You would use Conditional Formatting to adjust the cell fill color based on the status. That would be the button to the right of the paint roller in the top toolbar.
Re: Formula for business days?
Hey @laura.sandoval,
You can use IFERROR for that. It'd look something like this:
=IFERROR(NETWORKDAY(5/5/24, 5/10/24), "")
Hope this helps!
The new unified share button is now live for all customers!
Hi Community,
We're excited to share that all customers now have access to the new streamlined share UI experience that prioritizes one primary Share button in Smartsheet. Our goal with the redesign of the sharing experience was to help drive collaboration and make it easier to share your work. We have updated the primary share CTA in sheets to be easier to find, and we’ve made it easier to share full solutions instead of individual sheets and reports when appropriate.
Specifically, we are:
- We are introducing a drop-down menu under the share button. If the user is shared to both the workspace and the asset, they can select and share either the whole workspace or just the specific asset.
- We are removing the share button in the solution panel.
- We are removing the share to workspace button currently in the share modal.
All users are eligible to use the capability
Click the sharing icon in the upper right hand corner to experience the new sharing interface
If you have any questions about sharing please check out our updated help article.
You can also stay informed by Subscribe to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Cheers to collaboration and transparency and our new enhanced sharing experience!
Elektra Helde | She/Her | Product Marketing
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
@brianschmidt terrific! Thanks for the detailed clarification on what does and doesn’t show up under those conditions! Very helpful indeed!
Re: Introduce yourself & get to know your peers!
Hi @Rebeca S.
Thank you for sharing these resources. There are many interesting webinars and more.
Best regards
Re: What is the longest formula you've created?
I once had to create a dashboard to help myself not forget how I created one of the most complicated formulas I ever needed. I’m sure there are more elegant ways to do what I needed, but I ended up with this to help create Deferred Revenue tools and metrics for financial modeling…this us fairly nutso, but maybe will provide some of you some chuckles :)
Re: IF THEN statement
Hi @PMOGal,
Try doing it at the row level and see if that gets what you want.
=IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "No")
Hope this helps,
Dave
Re: Triggering User when multiple automations are set up
No, it's not batched in any way, and it is supposed to be triggered by a new row being added. However the first notification, which is also triggered by a new row, has a second action that changes one of the fields to "NEW," so I think that change to the row is my culprit. I instead added the second notification as a second action within the first notification's workflow (and prior to marking the one field as "NEW"), so problem solved! :)
Re: Resource Management API - Users
Yup, easy to work around. If you take a look at the API you'll see that they don't return custom fields with the bulk users api. You have to loop through and call with the ID for each user. Here's some code that can guide you.
test.py
import requests import os import time from datetime import datetime # Save your access token for RM in your environments variables. ACCESS_TOKEN = os.environ.get('TOKEN') BASEURL = "https://api.rm.smartsheet.com" USERS_API = "/api/v1/users?per_page=100&page=1&fields=email" CUSTOM_FIELDS_URL = "/api/v1/users/{}?fields=custom_field_values" def test(): # Getting the user list user_api_result = requests.get("{}{}".format(BASEURL, USERS_API), headers={'Content-Type': 'application/json', 'auth': '{}'.format(ACCESS_TOKEN)}) user_list = user_api_result.json() for user in user_list["data"]: # Sleeping here because the API has pretty restrictive limitations and I don't want to spam GChat time.sleep(1) custom_fields_url = CUSTOM_FIELDS_URL.format(user["id"]) # Getting the custom fields for each user in turn custom_result = requests.get("{}{}".format(BASEURL, custom_fields_url), headers={'Content-Type': 'application/json', 'auth': '{}'.format(ACCESS_TOKEN)}) user_custom_fields = custom_result.json() print("User: {} has the following custom fields: {}".format(user["first_name"], user_custom_fields["custom_field_values"]["data"])) if __name__ == '__main__': test()
You'll note that the custom fields data is a list, so you'll need to loop through that or squash it with a list comprehension or something.
Have fun! 😎
Re: Introduce yourself & get to know your peers!
Welcome to the Community. 😄 We have many resources available that can be helpful as you learn how to use Smartsheet. Don't hesitate to ask any questions you may have, the Community will be happy to help.
Wishing you a great learning journey, and a nice day!