-
Centrally managed column values? Multi-project rollup?
I'm a SmartSheet noob investigating whether it's possible to recreate in SmartSheet what we've done in Airtable. I'm pretty sure SmartSheet can do what we need, I'm just unclear on how to adapt the flexibility of Airtable to fit SmartSheet's more typical enterprise app structure. Questions: Does SmartSheet have a concept…
-
Red / Yellow / Amber formula
Hi, Can anone please suggest for my sheet that is formatted as shown in the attached image and for the following conditions if risk/issues cell is not blank and due date is in the future then yellow if past due date then red if past due date and with risk/issue cell not blank still red if not past due date and no…
-
Multiple User Views on Dynamic View
I am creating a dashboard that contains Dynamic View. Is there any way to create multiple views for different contact lists? I know that dynamic view can be based off of a contact list or group, but is it possible to have a "view all" for someone higher level? So a manager can see the entire list while a lower level can…
-
Lookup To Return Multiple Results
Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc.…
-
Is there a way to track when a comment is added with system columns?
Adding a comment to a row does not update the "Modified By" or "Modified Date" column. Is there any way to change this?
-
Column Formulas in SUMIFS
Hi there, I'm currently using a SUMIFS formula that is as follows: =SUMIFS({v4 Hours}, {v4 end}, MONTH(@cell) = 12, {v4 Group}, OR(@cell = "AD", @cell = "Freelancer")) I want to sum the task hours column {v4 Hours} if the End Date for the task is in December, and the group has one of 2 values. Each {reference} refers to a…
-
Formula in % Allocation Column?
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "% Allocation" column to calculate the % Allocation for my users. The users must ensure that both…
-
Dual parameter formula to capture last entered date versus last date of column?
Currently have a sheet that allows an end user to utilize a drop down and date column to quickly input their activity related to a row. Once entered, a workflow copies the date and activity to a separate sheet with dates placed into individual columns. Using a MAX/COLLECT reference formula I am able to retrieve the last…
-
I will send you $100 USD if you can help me solve this
Hi there, If you can help me solve this, I will send you $100 USD via Paypal. My company generates leads for car dealerships across Canada. We will be using Smartsheet for our dealer partners to manage the leads we assign them. Each dealership will have their own sheet which their sales people will have access to (as well…
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…