-
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.…
-
Identifying Batches Of Survey Results
Scenario: When a team leader is signing off of their contract, a survey is sent out to each of the team members to evaluate their leader based on simple [5 – very good] through [1 – very bad] questions. Each question has the rating 1 through 5. When the team leader signs off, the managers review the results of the survey…
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
Increased Cell references
Anyone know when (or if) Smartsheet plans to increase the number of cross-sheet cell references? I am getting this message now in my sheet, and its frustrating because I feel I have only started to truly make my sheet smart and truly useful. Does anyone have any "best practices" to share? I am currently referencing 5 or 6…