Jaye Tatone’s Profile

points
2713
Department
Marketing

First.....Im so happy the Multi-select feature is now available - so thank you.

This leads me needing some assistance.  I have played around with a LOT Of different formulas trying o find a way to capture this information.

I am needing help with trying to find a formula  to do a count of selected

Why were we not informed about this? Copied below is the exact email I received from Smartsheet Product Info on September 17th. This is very frustrating to have a functionality stripped with no warning. We ran through this list with our teams to determine whether or not any of our free users would

Hi all, looking for suggestions based on others' experiences. We have a series of dashboards and their respective back end sheets that occasionally throw formula errors for various reasons. I'm hoping I can leach some ideas from the Community on creating a master report/notification that informs us

Anybody want to take a stab at this?

I'm helping a design team estimate their effort based on the details of the work coming in. The formula will be an INDEX COLLECT with some nested IF statements. Note that this is currently on a test sheet and in the end the formula will live on an overall tactic

Hello,

I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced.

In the the "Edit or Remove links" > "Outbound links" section of the Cell Links: Consolidate or Maintain

Hello all, using the following formula:

=COUNTIFS({TACTICS design resource}, AND(@cell <> "", @cell <> "N/A"), {TACTICS status}, AND(@cell <> "Cancelled", @cell <> "On hold"), {TACTICS status}, <>"admin", {TACTICS project number}, <>"*N/A", {TACTIC actual delivery date}, MONTH(@cell) = 12)

I'm

I am having trouble with this error and need help with the formula

4 Columns (let's call them A,B, C, F)

Formula used is: =SUM(Column B + Column C)/ Column A

How do I make Column F equal Zero (0) when Column A is equal to Zero (0)

Thanks,

Hi guys, I can get the following formula to work without issue:

=IF(TODAY() = DATE(2019, 8, 9), SUM([2019 Aug]:[2019 Aug]))

What I can't do is update the logical expression to be if today's date is between Aug 1 and Aug 31. Essentially I want a self-updating formula that will always show me the sum

Has anyone started using this new feature?  It's unclear to me what it is this summarizes.  How are other using this, any

Seems like reports are refreshing super fast now.  This has always been a huge problem for me because I refused to use smartsheet live in a meeting because reports were just so slow to load.  I'll admit that part of the problem is probably my design (pulling data from up to 150 files). Fingers