-
Convert formula to column formula without losing existing cell data
Hello, I have a sheet where I'm trying to add a formula as a column formula so that it applies to new rows, the issue is many cells in the column already have data (Date column) that I don't want to lose. The formula is an INDEX/MATCH that is referencing another sheet to obtain a modified Date. I have a trigger to copy a…
-
System Availability
I have three systems, let's call them A, B, and C. When I cluster A + C, I would like to prevent users from being able to select either System A and System C as standalone system requests. Both standalone Systems A and C should be marked as unavailable from the drop-down menu until the project finish date is in the past…
-
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…