-
How to change new notification receipt ?
When I try to add a new notification, the "Notify" column shows my name and is frozen. Is there any way to unfreeze it, select or input the name/email I'd like to send to ? Thank you.
-
IF AND Formulas - Where am I going wrong
Morning All, I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please? I need the below: If today > actual start date & today is > actual end date & % complete < 100% = Red If today > actual start date & today is < actual end…
-
Multiple predecessors
I am new to smartsheet. It's a great tool but have run into difficulty working this out. I need to apply 2 predecessors to a task. One being that the task has to be completed no less than 2 weeks before the final milestone of the project (the event date). The other being that the task can only start once a prior task has…
-
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…
-
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…
-
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…
-
Smartsheet Contributors score?
Hi I am puzzled that for about two weeks in July my Score didnt move despite my efforts to help as many users as possible? yesterday it jumped about 100 to 4080 now it is stuck again? Not really important but i'd hate my colleagues to think i'm not pulling my weight? Especially when Craig is way past 18,000. RichardR
-
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…
-
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…
-
Report Headings in Sights
Hi Team, I have a report in my Sight and for the life of me, cannot work out how to increase the size of the headings! I've looked for options in the original sheet, the report AND the sight, and cannot find a way to do it! Please help! Pic attached to show you what I'm talking about. Cheers,
