-
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…
-
data synchronisation issues
Context: I have recently started testing Smartsheet, though the organisation I have joined has some established uses. So I am in a familiarisation and test phase. Talking to another user recently, he expressed concern about the Smartsheet user experience and data integrity / synchronisation. He had updated a cell in a…
-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
