-
Is possible change the ADM e-mail?
I have a problem and I would like to change the ADM/Owner e-mail. Is that possible? If yes how can I do it? Best regards
-
Indent using a non-US keyboard
I'm using a keyboard where '[' and ']' are found using "Alt GR + 8", "Alt Gr + 9". How do I indent using the keyboard? "Ctrl + Alt Gr + 9" does not work. I have also tried using Ctrl + M as proposed in another thread. Thanks Lars Bo Wassini
-
IF Function
Hi, I want a formula to report if the Actual Start date is greater than the Baseline start then put the tick and cross symbol. The formula works however even when there is no actual start date entered it will still populate. I need a condition for if it is blank then no symbol appears. Can anyone please help me out? :)…
-
Checking for conflicting assignment dates across two columns
Long time reader, first time poster--this one has a few people stumped. I have a variety of events with Start Dates & End Dates. Staff members are assigned as a 1st Guide or 2nd Guide (its critical we differentiate which role they have been assigned). I am looking for a way to pop a warning symbol when one of the names is…
-
Auto copy primary column
Hello, I have inherited a smartsheet used for asset tracking. Asset ID number is currently the primary column but I am changing that to an auto generating column to prevent any human errors that I have noticed. Since the primary column can only be numbers/text I have created a new column that is auto numbering. What I…
-
Control Centre - Bulk Update column error 1163
Hi, I'm trying to copy a hidden text/number Column in my source Template which has a simple column formula. The setup is simple and is below. However when I try to run it through a test sheet i am getting the error below. Any help would be appreciated.
-
Dynamic View Scrolling Up after saving
Currently I created a dynamic view that allows users to input data to my database of information under the details panel. This has been working great but with one wrinkle. For people who I've assigned long lists of items to add information, every time they hit save to add the data the page scrolls all the way to the top.…
-
Setting up billing rates in grid view?
As a newbie, I'm trying to set up billing rates in Grid View by job title, but I'm finding the help documentation in SmartSheet lacking (see attached screen shot). Is this even possible in Grid View? Or is Gantt View the only option? Or, is conditional formatting the only approach? Any input or ideas would be greatly…
-
Automated symbol isn't switching
Hi everyone, I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal to 100% mark it green. This is what I got: =IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target…
-
Issues with Cross Reference and VLookup
I have been trying for several days to get cross referencing to work, it is stuck in the processing status is what I have noticed. I even tried to use different browsers to see if that was an issue. In order to provide data for testing, I cut down my files to remove sensitive data and just included the necessary data, now…