-
'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…
-
Search, If & Input
I've been having some difficulty trying to solve this one: * I have a master sheet where forms are inputted * For each row there are two columns I need to set up in an IF for, and one where I need a value inputted from another sheet * I imagine it like this: IF column 1@row = {other sheet} …This reference should search an…
-
Saving Sort criteria for later use
It would be very, very useful if the users could save the sort criteria as a preset. That way, they could choose from a list of previously used Sort criteria. We have a Smartsheet with a lot of different columns that we contstantly need to change the sorting view, so this would speed up the process.