-
Sumif / Countif
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…
-
How to select different image source (camera app) when adding photos
Hello- Is it possible to default to a different camera in Android app when selecting to take a photo. By default the smartsheet app uses Android camera. I would like to use Skitch so we can add notes, arrows, circles, etc. to the photo. We are using this for a production line checklist. THANK YOU!
-
Automatic Sorting a Spreadsheet into new columns
Hi! I have not used Smartsheet yet. I have a question and maybe Smartsheet can do this. Every year at tax time, I download all of my bank expenses to a spreadsheet. There are hundreds of expenses all mixed up from the last 12 months - electricity, mortgage, car, etc. I need a program that will sort the expenses by…
-
SUMIF Returning $0
I have a "Status" column with dropdown options of "Pending" and "Accepted". I have a second column (CAR Amount) with a dollar amount in each cell. I want to sum the amount of all rows marked "Pending" and then do the same thing with all rows marked "Accepted". I have tried: =SUMIF([Status]1:[Status]64, "Pending", [CAR…
-
Sending updates
Good morning, i am trying to send some updates on smartsheet to users that i have as my contacts, but they are getting the notifications about 30 minutes to 45 later. is there anything i could do to fix this?
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Tasks on Track and Off Track Count
Good Afternoon All, The Vice President has decided that for each project plan he wants to know the below information A count of the number of tasks that should be in progress (using start date) A count of the number of tasks that should have started and havn't (using % complete and Start date) A count of the number of…
-
task management...answer might not be as simple as question suggests!
Dear SS Fans, For many years I've been using a MS plugin called GTDOA. The joy of this PI is that at the point of sending an email I create an MS task, link the email to the task, tag to a category, set a due date, reminder date et al and then when I press send an MS task is created and I can forget about what needs to be…
-
Plotting X, Y Axis
I have a smartsheet that calculates necessary values along an X and Y axis. Does smartsheet have the ability to plot points on a graph? I looked into smartsheetapps.com but didnt notice this function. I can export the sheet to excel and plot just fine. I am trying to prevent export and extra processing since everything…
-
Creating a non-updating date
This problem specifically references two columns - The first being a flag column and the second being a date column. When the flag column is flagged, I would like the date column to get the date the flag column was flagged - and stay that date. Here is the formula I am using right now: =IF([Flag Is Flagged]4 = 1, TODAY())…