Greetings, We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis. We have several groups of contractors that view one master sheet and each of …
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] wi…
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to lo…
We use the importrange function reguarly within our Gsheet implementations, and would like to allow certain cells in smartsheet to receive regulary push updates from an active gsheet via this function…
I'm trying to do a count of how many staff have uploaded a particular document. I have who has uploaded the document and how many staff in total, and I want to display that as a percentage on the shee…
I have the same sheet for 7 different individuals that has 12 columns and 38 rows...each cell is a check box. I want to create the same sheet that shows a count of each sheet per cell. So, how many of…
I am having some trouble with creating COUNTIFS functions that reference cells across multiple sheets. I'm trying to create an active dashboard that will reflect performance data over the following pe…
I created a pretty intense sheet to keep track on invoices and receipts. I have an "Action" column that is a drop down column. Here are a few of those "Actions" Request Sponsorship Submit Sponsorship …
Trying to get data from one sheet to another by matching on Deal ID to the Requests sheet from the Salesforce sheet Could someone please help me for the formula for this? this would be an import from …