-
Help! Multiselect Column Formula with INDEX, MATCH and HAS
Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smartsheet -Dept Attention column is a multi-select dropdown -Department Contacts column (in green) is a contact list that allows…
-
Wrike/smartsheet Integration?
One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have to pretty much develop it. I hope to show the team all the great new functionality we…
-
reoccurring weekly task with auto updated due date
Hi, I'd like to set up a reoccurring weekly task. When completed, it would reset the row status from "done" to "ready to work". The due date would auto-advance by one week when the status is reset to "ready to work" NICE TO HAVE: I know from the get- go that some months this task won't occur at all. Can I schedule the task…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Translation of text in sheets
Hello everyone, I would like to create a sheet that will be mainly consisting of text database and I need these to be translated into many languages so everyone across our company can understand it + customers, people in the production (who are not familiar with english) etc. Is there a way to translate text in sheets? I…
-
Formula: CountIf
Here's the situation: I have seperate source sheets for each function (Human Resources, IT, Finance, etc.) that syncs with data mesh (copy data) to a master sheet. However, sometimes rows get deleted from the source function sheets and then our master sheet still has the deleted row on it. I'm trying to have a checkbox…
-
[QUESTION] What (and HOW LONG UNTIL) Enhancement Requests become Features?
Hi, After using Smartsheet for about a year, I have not found where Enhancement Requests become features in Smartsheet. It seems that there is a chasm of disconnect between the Community's expectation for Enhancements becoming Features and that of Smartsheet. So, what's the process to vet out Enhancement Requests and plan…
-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying to…
-
What formula to use to count all instances of a value across multiple columns.
Hello, My colleagues have set up a sheet to help them track sustainability actions in their department. They've asked me to help with setting up reports and a dashboard that summarise and calculates the types of actions across the 4 Action type columns, as well as summarising further by team. As you can see there's been an…
-
Wacky Start Date When Using FF in Predecessors
Hi there, Working to update a plan today and I noticed that the use of the FF Predecessor Type will cause some weirdness with the start date. I've put an example in the graphic above but the summary is this: If you have two tasks that have the same duration and you want their completion dates to line up, the start date for…