-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
-
Dashboard - how to change Metric Widget data source after time of creation
How do i change the data source of a metric widget? You can 'add data' but this adds a new one. In my particular use case we can now copy and paste widgets between dashboards, however this is no way to edit the data, ie use the widget as a template. For me, we have a standard project template, and want a standard dashboard…
-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Thank you all for joining the Community Scavenger Hunt! 🎉
Smartsheet Community! You all showed UP for our launch and celebratory Scavenger Hunt! Did you have fun? I hope you're digging the changes and ways to connect with other Members. Your energy gives us energy. A note that the Scavenger Hunt is now CLOSED and we have contacted the 10 winners. But don't dismay if you didn't…
-
Trouble with IF AND formula - i need some help :o(
Hi everyone, need some help, I need a formula to display 5 different outputs based on the conditions set out below, I have tried this based on a IF(AND formula and not getting much back, I can get 4 and 5 to work using =IF(Cancelled@row = true, "5. Request Cancelled", IF([Upload to IMS]@row = true, "4. Request Complete"))…
-
Meet the new Smartsheet Community + join the scavenger hunt to win! [CLOSED 6/23] 🥳.🔍 🗺
Welcome to your new Smartsheet Community! Thanks to your feedback, we’re thrilled to re-introduce you to THE place to get connected with people around the world who are driving achievement at work with Smartsheet. Jump in and explore the new platform by completing the site-wide scavenger hunt and you’ll be entered to win…
-
Update your Community email address or password
Email Address in Community The online Community uses either your Smartsheet or Brandfolder account to authorize access to the Community. This means that if you update your email in your Smartsheet app account, your Community profile will automatically update to associate your account with this new email address as well!…
-
Edit Posts in the Community Forum
It would be great if you could allow a way for us to "edit" our own posts. Occasionally a typo is noticed only after submitting the post and I feel it would be a nice addition to allow us to fix any mistakes we may come across after submitting a post.
-
Workspace at work
The home spot needs a touch of TLC, but same sort of jam going on the bread there.
