-
Symbols Column not Displaying Symbols per Formula
I have this JOIN statement that works but it does not show the symbols setup for that column. Any idea why? Your help is appreciated in advance! =JOIN([Previous Week Trend]27 + " " + [Previous Week Trend]30) returns Unchanged Unchanged
-
How to reference entire column from another sheet
Hi, I'm new to smartsheet and i would like to know how can i reference an entire column from another sheet, no criteria needed. I just want to return the data from sheet 1 column 1 to sheet 2 column 1, is there a simple way to achieve this? I have tried to use =INDEX({SHEET 1 RANGE 1}, 1), it will only return data from the…
-
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…