-
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…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
How to set-up net-30 days in Smartsheet
Although seems very elementary to set this up, however, I am having the toughest time trying to build this "net-30" into our invoicing report. Can someone help me out? Thanks in advance!
