-
BOX/Smartsheet Best Practice
Does anyone use BOX with Smartsheet?
-
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.
-
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…
-
Primary column not sorting properly
My primary column contains numbers (1 to 250 and growing). When I sort I get the 200's first going up then the 100's. They are numbers as near as I can tell and not text. If I use the add/remove decimal places tool they respond properly? What am I overlooking?
-
Enable/Disable cells
Hello everyone Is there a way to make enable or disable a cells according to the values of another cell. A kind of conditional formatting with making enable or disable cells. Thank you in advance
-
Cannot edit after up-grading from free/trial
Hi I am the first timer to Smartsheet. Yesterday, I made the up-grade, but then, as soon as I did this, I cannot edit any sheets. I get an icon pops up indicating " You need to up-grade" . Come on.... I did up-grade.. I still had 8days left for the free trial. I would like a help ASAP so that my teams can star using it.…
-
Simplified Resource Management
Hello! I am attempting to develop a simplified resource management tool that would allow me to see what users are working on what projects/tasks based on the email in the Assign To column. I do not require the time allocation, just name/email and the number of assigned tasks across multiple sheets and workspaces. Some of…
-
Can I filter child rows based on Parent row task name
Is it possible to filter a sheet based on the Parent Row task name? For example, if I have some child tasks that fall under the parent task name "Electrical" and some child tasks that fall under the parent task name "Mechanical" and I want to only see the parent and child rows for "Electrical". My sheet may have several…
-
Nest IF limit or error in statement
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If there isn't, then what am I doing wrong here? OR is there a better way to do this? The error I get is #INVALID OPERATION (no…
