-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working.…
-
Workspaces do not appear on "link to" file list
In taking the eAcademy course, in the Cell Linking chapter, I am told to link to a file in the eAcademy workspace. When I try to do that, I notice that I have no access to any workspaces from the link to functionality. I can get my learning about this concept from the class. My concern is, moving forward, will I not have…
-
Dropdown List Multiselect Feature Request
I would like to submit a Smartsheet feature request that will allow users to do a "Multiselect" for a Column type of "Dropdown list". At the moment the only way I can do something similar is to create multiple checkbox columns, which makes the sheet hard to use due to all the extra columns. In Smartsheet today, you can…
-
Duplicating Column Properties
Is there a way to insert additional columns and copy the properties of an existing column? I would like to create multiple columns utilizing the drop down list feature and I can't find a way to change it from the default of "text/number".
-
Cross-sheet references
I'm getting the error code #CALCULATING, which I think is because I must've gone over the 25,000 limit for cross-sheet references. The sheet originally had upward if 4500 rows and I've removed more than half of them now but I'm still getting the same error. Can anyone help with this please?
-
Help expediting Data Entry
Greetings, Looking to get some help speeding up our data entry process. We have a note that looks like this: Name: John Doe Phone: 555-555-5555 Email: email@mail.com-and about 15 more fields. These fields need to be taken from the note and manually input in our Smartsheet. I would like to know if it's possible to paste a…
-
'Find & Replace' functionality in SmartSheet?
Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?
-
Auto Alphabetize in a Sheet
Is there a way to have a sheet auto alphabetize? I have a sheet with thousands of rows and users generally enter new rows at the bottom/next available row.
-
Can it be done? Creating a workflow with a form from a seperate spreadsheet.
Hello - I have setup a sales pipeline spreadsheet and a separate proposal tracking spreadsheet. I would like to create a automatic workflow in the sales pipeline sheet so that when "Proposal" or "Pitch" is selected as a status in the pipeline a automatic workflow takes place to present the form for the proposal tracking…
-
Receivable Over View
Dear all, Our current receivable has many terms such as advance payments / 30-45-60-120 days deferred. We are maintaining it in an excel sheet but I am afraid some receivable might be missed. What I am looking for is a sheet where I enter the customer invoice value and by when what percentage of that value will I receive.…