-
Zero Formula
Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.
-
Drop Down List on Dashboard
Is there a way to place drop down lists on the dashboard yet? Need direction..
-
Merged: Extra Fields For Contact List
This discussion has been merged.
-
How to change star symbol to number equivalent?
I want to change the number of stars in a symbol column to a number equivalent in a column next to it, but do not seem to have the formula correct. It looks like it is a valid formula, but all I receive back is a blank. Here's the formula: Any thoughts on how to make this work would be appreciated. Thanks, Bill
-
Resource Management by Smartsheet -- Good for Small Business?
Hello! I am helping a small high-end contractor optimize his business use of Smartsheet. His organization has a Business plan. He would like to be better able to track workloads of his organization week-to-week & also highlight when subs are overallocated. Wondering if RM is a good option (or if it would be overkill). His…
-
Error #BLOCKED
Buen día, se me está presentando el siguiente error en una de mis hojas. Actualmente en la hoja hay 2890 filas con alrededor de 90 columnas (la gran mayoría formuladas). Al intentar mudar filas a otra hoja para depurar la memoria sigue permaneciendo el error y las celdas aparecen "#BLOCKED". También, ya intenté quitar…
-
Daily Reporting to Document Generation
Good Afternoon, Our construction firm utilizes a standard Gantt chart sheet to track our project's daily reports. Under each category of work we have milestones, i.e. Carpentry :: Framing :: Drywall etc. Under each milestone we add a child for that days work, i.e. Drywall :: Day 1 - Mobilized :: Day 2 - Started Hanging…
-
Trouble with Chrome Base web interface, no horizontal scroll
Hello - Is anyone else experiencing this? We have several google "chrome base" desktops, (just like a chrome book laptop, only a desktop).....while working from with in the chrome web browser, on the chrome base, we are not able to use the horizontal scroll in the grid view. We have to resort to selecting a cell, and using…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Enable multiple views of same sheet within a workspace
I have a sheet that displays information that is valuable as both a grid and a calendar. It would be nice to be able to make a "copy" that is a linked clone of the original sheet in a locked-view version of that sheet. For my use case, the main sheet would live as a grid, then a calendar copy could be made that is locked…