-
Formula to return 'TBA' if cell contains text 'TBA'
Hi, I'm currently using this formula which works: =IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun")))) However, I…
-
Newbie Question: Want to Count "Product Name" but only if its date is in the future
Hello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting to highlight it if there is more than one time the product is mentioned.…
-
Back up not complete
I requested a back up of my smart sheet on the 24th. It is still pending. Who do I contact to get that back up. Smart sheets won't let me attempt another back up with that one still pending.
-
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.…
