-
Form Query String - Using Multiple Values
I've been doing some research on how to append values from a sheet, to a form link, so that when the user clicks on the link, certain fields are pre-populated. I've run into two issues that I'm looking for some help on: Can you add more than 2 values in the query string? I'm referencing fields in a sheet, so they're not…
-
Dashboard/ Report "Current User" Not Updating
Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filter based on "Current User", which is reading the Project Manager Column (set to Contact List). The issue I'm seeing is if…
-
Heavy Form entry traffic + Complex column formulas = Inability to SAVE manual sheet changes
Story time. This is a long one, so buckle up! This post is for anyone who might be having issues with saving changes on sheets with complex formulas while many form entries or new rows are being created. (TL;DR summary and the real Discussion Topic at the bottom!) Last week, I put together a small Smartsheet solution…
-
How to form a =COUNTIF Column in reference to an already formulated 'Unique Column'
To further explain in reference to this community post. here, https://community.smartsheet.com/discussion/57396/generate-list-of-unique-values-index-distinct-vlookup/p1 I've successfully been able to apply the formulas suggested from that post and build out a column of unique names. Now in a separate column I'd like to be…
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
-
Adding detailed information to a row / task
I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do we intend to implement it? I.e., detailed info rather than simple notes etc. I can go to Card…
-
Is it possible to disable sorting in Dynamic View?
I want to disable sorting in Dynamic View to prevent users from messing with the data order. How can I do that ?
-
% Complete Column
Anyone else having issues? I cannot update this column in any of my sheets. It just jumps to the next line of it you hit return it auto adds a full line.
-
Using sumifs to tally up certain date ranges
Hi All. I'm working to understand the more complex formulas of smartsheet but have been stumped. I'm looking to sum the work area total amount of a task based on the start and finish dates on the Gantt chart. I want to see what we will bill per month. The Gantt has each work area with dates and work area pricing totals. I…
