-
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.
-
What is the best way to backup my data in Smartsheet?
My company is adding a lot of important and senstive data to our sheets and I am concerned that one of our users might accidently delete data that we need. What would be the best back to backup all of our sheets? Is there feature that will automatically backup our sheets?
-
How to update rows from a custom form...
Hi, I have a Smartsheet that contains information about different pieces of work. Each row is specific to a piece of work and it has multiple columns, one of these is Status. I display this as a Kanban using Card view. When I change the status of an item to Completed, I want to automatically send a form to a contact in one…
-
Dashboard Issue (Displaying Old Content)
Hi I have a dashboard that sorts things by scheduling this included things that need to be scheduled, have been scheduled, in-progress or waiting for feedback. This is all ripped from a single sheet, put into reports and displayed on the dashboard. I have been having issues with things being marked, still displaying in the…
-
New Here; Automation question
Hi, I'm excited to start using Smartsheet to manage all of our workstreams and related tasks and issues. I was wondering if there is a way to automate the setting of one field based on another, so a row update? E.g. I mark a task Complete and it moves it to the (card) list Completed? What I'm finding in automate workflow…
-
Document Checklist(s)
Hi all I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. We could have individuals or entitys on the loans as well. I need to be able to pull…