-
Display N/A if Join/collect formula finds no result
This discussion was created from comments split from: Index Match with multiple results?.
-
I get the 500 error often, seems to be smartsheet network issue or system issue.
How do you guys handle the error handling, do you retry the api CAll in couple minutes?
-
Deleting old templates so they can not be selected as an option when selecting preexisting templates
I have made a project in branfolder and then created a template from that project - for our business to use. I am trying ot clean out the template options they have to choose from when they select > Create new asset > Create from a existing template. That is bringing up templates that I have already deleted off the main…
-
Show empty lanes in timeline view of report
Hi, I am running timelines on a master sheet for high level tracking of a few different things. Rather than adjusting the timeline settings to get each view needed, I’ve created a set of reports set to timeline that are permanently grouped and filtered as needed. I want to use the “Show empty lanes” option under Group in…
-
Clock In and Out with Lunch Time Stamps
I need help creating a formula that will calculate my employees time in and out along with their lunch break.
-
Total Float Function: work with multiple predecessors
Enable Total Float to work with multiple predecessors. Currently, Total Float will only calculate correctly when there is a single predecessor for an activity.
-
Smartsheet Admin Center
Hello, I unshared a user from all of our sheets about a month ago through the Admin Center. At one point, this user had Admin access on many sheets. When I run the User Report, the user is still showing as Admin or Viewer on sheets they were unshared from. I’ve manually checked several of these sheets and confirmed they…
-
SmartSheets Changing Date Format (UK to US) in some emails?
We are UK based and use the Day/Month Date Format (i.e 09/02/2026 - 9th of Feb 2026) In some, but not all, of the "Send.." rows email, the date format changes to the American version (02/09/2026). Is there any way to stop this happening?
-
GEO code on photo attachments
Is there a way to keep the GEO coding on a photo attachment. We have photos that will be attached to a Smartsheet. When the document is submitted the office staff are going to need to download the photo and upload to a Government site that requires the photo be GEO coded.
-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…