# bday2329’s Profile

points
76

Good Day,

I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set

=IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down"))

The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up,

My team has been exporting a Smartsheet to Excel for over a year now then 5/30 we started getting a corrpuption error on our export to Excel (see attached Corruption1 & 2 Attachments).

Trying to firgure out why this is happening now. I submitted a help ticket to Smartsheets however they miss read

I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other.

I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID OPERATION (Red Arrow) however in the 2nd Smartsheet example (Blue Arrow) the formula works

In the

Need help with calculation of military time:

I have two columns that I am using to track Admission time and Discharged time to determine and average length of stay.

I am using military time for each column and storing the difference in a third column for each row

=SUM(([Discharge Time From ER]2 -

Hi I am trying to create a countif formula with multiple criteria . Heres what I am trying to do

Countif Column1 = 1 and column 2 = N/A or Received at home

I tried this formula but assume it is a check And for all 3 conditions as I get a value of 0

=COUNTIFS([Campus Id #]:[Campus Id #], =1, [ASA

Background:

I have created a form to capture Company personnel’s proposed ideas to improve cost savings, quality and safety. With this I have also created a Dashboard to give a snapshot of the progress of all Idea’s submitted.

On the dashboard I created a button that I had intended for a person

Good Day,

I need so assistance, I am trying to do the following

I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met

if my "# of Days" column is > 138 and my "% Complete" column is < 50%

Here is my If condition - =IF(AND(([# of Days]2 > 138, ([%

Hello!

I've been having trouble with getting this formula correct.  Here are the details.

I want to count row A when "service expansion" is present only if row B has "qualifying" or "proposal"  or "Negotiation" listed.

I've tried several variations but can't seem to get this one!