Best Of
Re: July Question of the Month - Join the conversation and receive a badge
This year, my goal was to run four 5k races and train for a 1/2 marathon. Welp, a knee injury has canceled that goal. I've replaced it with developing my knowledge. :) I've started reading the 12th edition of USALI to understand hotel finance and working with a mentor towards PMP. Either way - I'm still building muscles 🤭
Darla Brown
Re: Fetching comments from a Smartsheet : Getting Error
I got it now Thank you so much help, Sheed ID was the part where I got confused, Now everthing is working fine
Thank you everyone who took their valuable time and responded back 🤗
Manik Salaria
RICEFW Template with Dashboard
Hello! I am looking to see if anyone has developed a RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms an Workflows) Template with a support intake form and Dashboard?
Christen
Re: Bridge: Copy partial Row example - error
Try this for the Row ID in the Get Row module:
{{runtime.event.rowId}}
Notice the end is "Id" with a lowercase "d". It is case sensitive but understandably frustrating when the "sheetID" is a capital "D". I always suggest going into the run-log and copying the reference from there to help avoid this.
Paul Newcome
Re: Canva & Brandfolder Plugin Search Not Working
Hi Isaac and Brandfolder Community, our Canva account executive brought the issue to their 'ecosystems team,' who confirmed that assets could only be searched using the tag functionality not the search bar, the plugin doesn't search metadata. I'm waiting for them to confirm if a user can search for more than one tag at a time. Stay tuned. I would love to hear if other Brandfolder users have figured out a workaround.
Best,
Jennifer
Jennifer Anna
Re: #INVALID DATA TYPE on an IF( function
Hmmm… Would this formula do it:
=IF(TermDate@row - HireDate@row < 730, HireDate@row + 1095, TermDate@row + 365)
All three columns are date columns.
jjg279
Re: Using data shuttle for weekly backups from smartsheet to sharepoint
@nadimsobhani , a solution we use is to:
- Download the sheet on a schedule to a SharePoint location
- Run a python script using task scheduler to rename the file.
We use a server synced to SharePoint using OneDrive and to run a BAT file that triggers the python script. The code below will need some tweaking.
BAT file
This file is triggered by Windows task schedule
@echo off
python path\to\your\script.py
Python file
This file contains the python code to rename the file.
import os
from datetime import datetime
# Specify the file you want to rename
original_file = 'example.txt'
# Get today's date in the desired format
today_date = datetime.now().strftime('%b %d %Y')
# Create the new file name
new_file = f"{os.path.splitext(original_file)[0]}_{today_date}{os.path.splitext(original_file)[1]}"
# Rename the file
os.rename(original_file, new_file)
print(f"File renamed to: {new_file}")
Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology
Neil Egsgard
Re: Dynamic Filter on Dashboards
You’re most welcome! 😊
It’s truly my pleasure to help — that’s what the Smartsheet Community is all about: supporting each other and sharing solutions so we can all get the most out of the platform. I’m glad the Dynamic Dashboard template was useful for you, and I’m always happy to exchange insights whenever needed.
Naeem Ejaz
Re: Dynamic Filter on Dashboards
Hi @Naeem Ejaz and @Julie Becker
Thank you for making me notice the Dynamic Dashboard template! It’s a great reference, and I appreciate your insights.
After reviewing the template, I found that its logic is essentially identical to the approach I shared earlier (see my post dated January 17, 2024). Even the “Max Row Helper” column name and structure are the same, which leads me to think that Smartsheet may have drawn on this idea.
Also, special thanks to @Andrée Starå for suggesting the idea of sharing a published sheet link. I’ve adopted a slightly different approach: instead of automatically loading the dashboard after form submission, I send users to the sheet where the form input lands. This triggers the report’s filter change, and a single dashboard refresh updates all the results much faster.
With this modification, I no longer need to manually refresh the dashboard twice—just one refresh shows the updated filtered data.
Thanks again for sharing and inspiring improvements on this method!
Re: July Question of the Month - Join the conversation and receive a badge
So this question is a really big one for me as I set a major goal of obtaining my PMP. I have been a PM in some for or fashion for over 15 years at this point. When I took my first IT PM role, my boss's boss was on the local PMI chapter's board and he was about to set up into the president role. He got into volunteering for PMI and I have been doing that since then. After several months in that role, I started to prep for the PMP exam. It was a mind numbing and extremely stressful journey. Oh, I forgot to mention that we just welcomed our son into the world during this prep time (Never prep for a major exam during the first year of having your first child). I got approved to take my exam and scheduled it. I went in feeling confident that I would pass, but I was soon met with the harsh reality that around only 20% pass their first try. I fell in the 80%. It was extremely discouraging, but I picked myself back up and scheduled a second attempt. Although I did better the second time, it was still not enough to pass. I basically said well this is not meant for me to have it and I didn't think about it again. Flash forward to 2020, COVID hit and I got caught in the COVID RIF at my job. A few months later I took another IT PM role. After a year there I told myself that its time to revisit the thought of preparing for the PMP exam. So I cleared it with my new job and they covered me attending another boot camp (I attended one and audited another during my last prep at the other job), and I started to prep. The company I worked for bought out another company and finding time during that merger to study was nearly impossible so I put off applying to take the exam. Things started to change at this company that I felt like weren't going to aid me in advancing in my career so I started job hunting and took a new IT PM position at another company. That was the best decision I made. From day one I expressed wanting to get my PMP and my new boss was 100% behind me. 2025 started and my boss pushed me to take another boot camp. I took my 3rd boot camp at the end of March and it went well until the class was over and the nerves started to set in. The realization of now I have a ticking clock due to the class having a if you don't pass the first time they will pay for me to retake it clause with a 90 day from the end of the class deadline to get the retake if needed. So I applied, got approved, and put my head down and studied like I have never studied before. I wanted to take the test in person, but the places within 15 minutes of me either had an opening before I felt like I would be prepared or one past my 90 day deadline. I looked at places a bit further away from me and then I noticed a place I haven't thought about in quite some time, Jones College in Ellisville, MS. I have strong connections there as that is where I obtained my Associates degree from many moons ago. I took it as a sign, plus the opening was for the day before the 90 day deadline. I went to sit for the exam and as I drove onto campus, I felt this calming presence come over me. I went into the exam building, one that I had been in tons of time before, and got checked in. Started the exam and as I went through the questions, I felt like I wasn't doing well. I finished the exam and went to check out. The lady at the front slid a piece of paper face down to me. I was so nervous when flipping that piece of paper over, but when I did, it read PASS!! Not only did I pass, but I got AT (Above Target) in all three knowledge areas they test for! I was so relieved and so excited! I waited until I got into my car to let out all my excitement! Then I remembered, I don't have to worry about the retake clause! I finally obtained my PMP, but the thought has creeped into my head, what cert do I work toward next?
Kleerfyre