[Update: I've found the solution and posted it in a comment] I am having some issues with a very complicated set of sheets I have created. Please be warned, I am stressing the limits of smartsheets, a…
Hello! The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signa…
Hello, is it possible to run a formula that gets me the following? If the status is “Not started” or “in progress” then count the number of business days between “date presented” and today, and if the…
I have Table with values as below and now I would like to get max value. How Could i can achieve the Results Required ?. Col1 Col2 A 2580 A 2380 B 1860 B 420 C 860 D 2760 D 2710 C 2750 Max Value -- A …
Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many ar…
So I have the following Sumif formula working and giving the proper result. =SUMIF([Business Unit]891:[Business Unit]900, [Business Unit]868, [Implemented FY18 (CUR)]891:[Implemented FY18 (CUR)]900) T…
Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal te…
Thank you for taking a look at this. I have one sheet where I am trying to show the count for a person on another sheet IF another column has a 1 in it. The 1 represents a checkbox in the ajoining col…
I am trying to make a Primary sheet for all of my escalation formulas (since i have 14 single sheets to use the TODAY() function). so... if(TODAY(-7)> {Date Cleaned}, "enter a name", " ") so if today'…
Hello all, Kudos to you all for such an active and friendly forum! I am new to Smartsheet and building an organization-wide task tracker for our accreditation and regulatory compliance for health plan…