Best Of
Re: Maps & Hyperlinks
I know this is kind of sloppy but after days of searching, thanks to cbsarge I was able to take what he posted and figure out how to adapt it to my own sheet to make it work.
my sheet looks like this. I need to be able to map the address in the JOB ADDRESS column so my formulua for Map it column is
="https://www.google.com/maps/search/?api=1&query=" + SUBSTITUTE([Job Address]@row , " ", "+")
Buildermen
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!
