-
Global Update - Find/Replace on Multi-Select Field
Are there any restrictions to using find/replace on a multi-select drop down field? I couldn't find any mention in the SmartSheet article but I'm having issues getting the global update to apply. I'm using 'Contain' to find and to replace with 'matching text'. The column does not have any restrictions to the dropdown…
-
Is there a way to group or organize workspaces?
My team has roughly 30 workspaces on Smartsheet that relate to different team projects. I would love to organize or group these based on which projects are being actively worked on. Some of the projects have been completed some projects are on hold or have been bumped to start at a future date. Is there a way to put…
-
Date field populating "01/01/1970" from form submission
I have a form collecting information on an event request where a "Date Selected" field is not present. Despite this, it seems that this field will intermittently be populated with "01/01/1970" when the form is submitted. The only automation surrounding this form submission is an update request that does contain this field,…
-
Automation triggered when rows are changed is happening on initial input
I have several automations set up to alert users when row data is changed. These used to work fine, but now they are triggering on initial input of the form. So now I get two emails each time rows are added, once for the new row automation, and again for the rows changed automation. Could this have anything to do with…
-
Control Center Dynamic Reporting NOT ADDING newly created worksheet
I have a blueprint utilizing the Dynamic Report Scope. The newly spun up 'Project Plan' IS NOT being added to the 2 reports I have selected. Why isn't this working? How do I make it work?
-
Dashboards: Only one of 100+ dashboards has zoom options?
Hi there — We have more than 100 dashboards used across the company. While most of them look great, we have an issue with one dashboard. It's the only one that has zoom options like this in the upper-right corner: This particular dashboard looks terrible — the font is tiny unless the user zooms in. Is there any way to…
-
How to get the last value in a data base
Hi dear community, I have a database where I can see the records of time spent in an area. Each employee needs to request an authorization and not to exceed a maximum time of stay in a period of time in that area (for example each month 10 hr are added although this varies depending on the type of employee). I have a sheet…
-
Count if formulas for assigned individuals
I have a work breakdown structure and I am trying to count the number of tasks allocated to contacts in the sheet. The data is spread over multiple columns. I have tried using this formula in a sheet summary - =COUNTIF({Assigned to SME for initial build}, "Joe Bloggs") + COUNTIF({Assigned to: SME 2 (peer review)}, "Joe…
-
How are you currently using Smartsheet for Marketing?
Hello fellow marketers! My name is Kevin Branscum and I am the Marketing Solutions Manager here at Smartsheet. I've spent my career in various marketing roles (brand marketing, product marketing, creative project management) and have been using Smartsheet in most of them. For my first question to the group, I'll keep it…
-
Date with Time uploading in Data Shuttle comes only with Date
Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P