-
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 to flag a task if not completed before due date
I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column. Ideally I'd actually like to flag it if the due date is tomorrow or already…
-
Does anyone have recommendations to moving sheets to another company's instance?
We have several partners who also use Smartsheet and may want to consolidate work under one Workspace. Any advice? I don't know if you can simply "Make an Owner". Thanks in advance!
-
Locking cells in sheet
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have…
-
Harvey Ball Status - Empty is now a blank instead of an empty circle
Hello, I noticed the Empty status of the Harvey ball is now a blank instead of an empty circle. Was there a reason for this change to make this operation less useful? The selections used to be Empty (light grey circle), quarter (1/4 filled), half (1/2 filled), three quarter (3/4 filled) and full (all full). Can we think…
-
Way to use grouping in reports with a multiselect column
Is there a way to group a report using a multiselect column? I have spent a while going thru the community posts going back to when the grouping in reports was released and see that this is something that has been asked about repeatedly with no solution or real work around. We have some sheets that require this…
-
Developing Library check-out list
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated process to get the copies available to update once when the number of copies is changed. When the form is submitted it says…
-
Count Multi-Select with conditions
I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a combination of Countifs and CountM or if I should use Collect, Has, Contains. I know this is simple I just can't put it…
-
Function to allow the import/export of multiple filters
If we'd be able to export/import filters to be able to share between users this would be an awesome feature that would greatly benefit our office. We have many people looking at the same Sheet but currently if we want to set up filters each user has to create them from scratch. I would think this could be an easy feature…