# Brian W’s Profile

points
187

Hello!

I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns.

So:

Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple

I am trying to Sum up the parent rows and am getting an "Unparseable" from my formula. Here's the formula. Please let me know what I am doing wrong. I have tried 1 to 4 closing parentheses as well. Same thing.

=SUM(PARENTS([ST Rev (\$)]5:[ST Rev (\$)]65)

Can we add to "specific date" and include recurring with a certain frequency with alerts and reminders? I'd love to set a reminder to the group to update a field on the 10th of every month, but I don't see a way to do

Dear Smartsheet:

I am a bit confused by the 25,000 cell reference limit.  In my specific case I am simply trying to VLOOKUP from a table where I have 700 rows and 17 columns.  That equals 11,900 cells which is less than 25,000 cells.

So, why am I getting this error?  It creates an incredible amount

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 -

Dear Smartsheet,

I love you. I really do. But these constant connectivity issues are making me think I need to find a different solution.

Yesterday I was trying to demo the wonders of your application but could not connect. And again today. The frequency with which the application is unavailable has

HI,

I have a formula  =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE  can anyone help fix this issue??

Please see attached excel with formula in Column D

We are having issues with pages loading and submitting forms. The following message is returned. I emailed support. Anyone else having issues?

app.smartsheet.com didn’t send any data.

Hello,

I've been trying to use vlookup to find data from a datasheet

Sheet A contains a column 1 with "My Name".

Sheet B contains column 1 with "Name" and "Number"

I want a column in sheet A that looks for the corresponding name in sheet B and returns its number.

I've looked up tutorials on this

I am trying to create a formula to count the number of projects assigned to one person based on the phase of a project. My criteria is that is NOT one of the following phases: Construction, Completed, Punch, On Hold. I know I need to use <> to create the "not equal to" but for some reason, I am