-
Document Builder Functionality
Hi, it's my understanding that 'RYGB Balls' column properties do not populate when using Document Builder -- symbols automatically converts to the associated text. I've tried multiple 'fixes' without success. Can you please recommend a workaround until this issue is resolved by the product team. Thank you in advance for…
-
Pivot App - How can filter a field
Hi there, I'm new using the Pivot App and I was wondering if there is a way to filter any of the fields in the pivot table. I have an excel pivot table that I'm trying to replicate in smartsheet from a master data that already is imported into my smartsheet. There is a column in the data master named "Current Status" with…
-
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…
-
Using a Vlookup and Sumifs in the same sheet ?
We have a master job list which we use to create our new project references. There are a lot of requests with a range of values ? I have a separate sheet where we populate with those projects we want to keep a closer eye on costs on picked up from other smartsheets ? The process being, I type in the job reference and it…
-
How do I restrict the range of dates in a Form input field?
I am building a reservation system and want to limit the days that a customer can select from in our Form. There are two versions on this - I want to restrict the input for the date field to only today and into the future, no days in the past. The other option I would like to do is to block certain days in the future that…
-
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?
