Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
BOX/Smartsheet Best Practice
Does anyone use BOX with Smartsheet?
conditional formatting by cells
Hello everyone, Is there any way to do conditional formatting by cells and not by column Thank you in advance.
Ability to lock an individual cell
I've seen a number of community entries referencing a desire to be able to lock an individual cell. I too would vote a resounding yes to a feature of this type. I've got a number of task list sheet where this is needed. My sheets have 10 major task and each major task has a number of subtask under them. My columns are…
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
Smartsheet unresponsive
I logged into my account and all my data is there but the page is unresponsive, I can't even select a cell.
Counting A Range of RYG Balls at Once
I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540. I have tried various formulas but I keep receiving and error. Can someone help me by letting me know what I am doing wrong? Here are few formulas I have tried. =COUNTIF(CHILDREN([Status of Completion]1:Status…
Feature Request: Edit Templates
Please provide an ability to edit templates. It is particularly clumsy to have to basically create a new sheet, delete the old template, and then save the new sheet as the template. That approach becomes unworkable when integrating with apps such as Zapier which would need to be updated every time you change the template…
formula or workaround...
Hello, I'm trying to build a sheet to use for our onboarding process. It would be nice to have on sheet for all positions. The issue is that all positions do not require the same onboarding activities. I would like to reference the job title / column and have conditions that would have the sheet only display or include the…
Progress Bar Automation, based on % Complete IF/THEN
I conducted a search but could not find this specific topic, so please forgive if I am repeating an existing question. Hopefully the subject line is incrementally more search optimized. BACKGROUND I am using IF/THEN formulas in my '% Complete' column to auto-populate a Progress Bar that goes into my status reports as a…
Display of a formula under/above row
Hello In some sheets i have long formulas to grab many intermediate values and eg. sum them in one cell. Problem is when I need to click a cell and this is hidden by formula. Can the formula be displayed under/above a row where I'm typing?
