-
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!
-
Customizable Banner Messaging to Subscribers
It would be great if we could customize the banner displayed within sheets as done by Smartsheet to market new features so that SysAdmins could message to their users without the need to do by emails. Examples: Renewal survey is about to launch, Did you know you can go to our company resource dashboard by doing xxxx,…
-
Primary Column Options
I am sure this has been said before but I would love the ability to expand the primary column choices from just text to also date columns. This would be really helpful for us folks in manufacturing when it comes to daily metrics.
-
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…
