-
Preserving Task Rollup in a report?
I would like to create a report to be sent out on a recurring basis that is essentially a filtered version of a report, (i.e. only showing tasks that have not been completed and filtered for tasks for a two week period in the future. I've been able to set the selection logic up in the report, but it does not bring the…
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Within a SUMIFS statement, can you extract the hour from a timestamp and use it as criteria?
Hello all, I have a problem that has been driving me mad - I would be grateful of some help! I have a spreadsheet where: Column A contains names (text string) Coumn B contains costs (numbers) Colum C contains a timestamp in the format dd/mm/yy hh:mm:ss I want to be able to create a formula that says "add up all the costs…
-
Greater than less than
Im attempting to make something that AUTOMATICALLY creates a way to change a percentage... our table goes like so.. 45% and up is 8% on another line anything between 44-41% is now 6% and 39% to 35% is 4% anythign less than 34% is 0% .. This is my equasion I think im on the right track but it does not give me the right…
-
Comparing offers for the same job from different providers
What is the esiest way to make a spreadsheet for comparing prices?
-
Smartsheet Development progress update?
Hi Travis and colleagues, great comunity forum, very impressed! Can we have an update on when we will see hours and minutes added to project plans, I seem to recall this was planned for the Spring this year? Also Gantt on Reports? We have clients waiting for these features. Thanks RichardR
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Send Update Request via API to Contact List User
Has anybody deveoped a solution using the API's to send Update Request from a sheet? Meeting with my developer to see if we can send an update request when the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup…
-
Formula to calculate start date, from end date
Hi SS community, I am trying to write a formula to provide a date, 45 days prior to the start date. Ie. = [Start Date]1 - 45days Appreciate the help.
-
=SUMIF Help please:
Hi Team, Formula not working…(#UNPARSEABLE) =SUMIFS[Value of Job],2 [Sold Date:]2,>DATE(2016, 12, 31),[Sold Date:]2,<DATE(2017, 2, 1), [Result]2, 1 Trying to get “Current Month Sales” to calculate “Sold Date” when “Sold Date” matches the current month we are in (January) * * When February rolls over I wanted “Current Month…
