-
Row limitation?
Is there a limit as to how many rows I can have in each sheet?
-
Viewing Cell History of Linked-In Cell
Our users are wanting to see real cell history on a cell that is linked in from another sheet. If you right-click the cell, it shows the history, but the user is shown as "Cell Link User", which makes sense. When you double-click the cell, it opens a pop-up with the sheet/cell it is linked from. It is not possible to…
-
I would like to hire an experienced consultant
I am relatively new to Smartsheet. I need someone to help setup Smartsheet to manage our book production schedule. We publish books (print and e-) and have managed our production schedule for many years with a Google Sheet. It is severely lacking. I have not yet signed up for any plan. I don't think I'll need 3 licensed…
-
Cell Linking & Count Down
Hi everyone, I am pretty new to Smartsheet. I need to create a 'central' sheet that contains a product number and the quantity needed, then this information will link to a number of different company sheets. When a company orders that product number they will fill in the quantity the ordered. I need that somehow lock up…
-
Restore from local backup?
Hi. I'm wondering how I can restore all my users sheets and workspaces from a local backup done with the smartsheet backup tool? Do I need to copy and paste everything ? Cause I tried to import the xls files and got an error that the "xls" file isn't a valid xls file which is confusing since I use the latest backup tool…
-
Are there limitations on CheckBox columns?
I imported an XLS file that has 4 columns that I want to convert to checkboxs. When I change the properites on all 4 columns to checkbox, the columns act as if they are text. If I change any of the 4 columns to text, the other 3 will show a checkbox in them. Is there some kind of limitation on the number of checkbox…
-
Template of % of Job Duties assigned, not based on "completed".
Is there a template I can enter staff's job duties to calculate the % of time? Example: Parent would be Office with child of "accounts payable", "mail", "conferences". I would like to enter the % of each child and then have parent be 100%. There would not be a "Completed" % column nor start/end date columns. Thanks.
-
Access list more than once
I'm in the home building business after I walk a house I make punch list for multiple subs to complete items that pertain to their trade. I have been sending "Send Update Request" to each sub. Some subs might have 10+ items.....they can't remember every item on the first time opened and would like to be able to refer back…
-
RYG(B) Balls - How do I reference the value of child cells belonging to neighboring cell/column?
=IF(children([Finding Status]11)="Closed", "Blue", "Yellow") The above attempt is failing me (i.e., "missing or invalid parameters"). Any advice? Thanks! John
-
Update Request with "add/subtract" formula to an existing number in a row?
A bit new to SS, so this may have an obvious answer, but I'm trying to set up a sheet to track inventory of, say, a dozen products. The initial setup is obviously simple, but then I want to choose the product rows that contain inventory quantities, and set up an automated Update Request to my delivery driver via email each…