-
Help converting and excel formula to smartsheet
Hi everyone, I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :) I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00" Is there a way to use the same…
-
how can i auto populate in smartsheets
I am trying to auto populate a column based on a selection I make in another column.
-
Trouble with Date Math
I have this formula in a checkbox =IF(Date1 > [Stop Date]1, 0, 1) Stop date is a date field with =TODAY() - 15 and Date is any given date. The idea is to check items where Date is in the last two weeks other wise don't check it. It does not work. If I enter a date newer than TODAY()-15 ir unchecks. If the date is older it…
-
COUNTIF Date is in the next 180 days from today
I'm trying to use the COUNTIF function to search a date column to count how many dates are within the next 180 days from today...but my formulas aren't working correctly. Failed Attempt 1: =COUNTIF([Renewal Date]2, >=TODAY(+180)) Failed Attempt 2: =COUNTIF([Renewal Date]2, >=TODAY()180) Failed Attempt 3: =COUNTIF([Renewal…
-
Calculate days remaining
I have an estimated project Finish date of 8/9/16 in a column "Finish". this date is in row 6 and row 161. I have entered a row name TODAY and set the date to current date in the 'Finish" column row 4. I attempted to use the formula: =NETDAYS([Finish]6,[Finish]4) I get no result or error message. Just the formula. What am…
-
Dashboard - Charting how many checked out of total boxes
I have a sheet that has checkboxes. I would like to be able to make a chart in the dashboard that shows percentage of how many checked out of total. I have a count for the checked boxes, but no total to reference. How would I go about this?
-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
-
SUMIF
Hi all, I am trying to add a range of cells on condition that it does not contain any value that is equal to/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135. anyone to help?
-
Calculating Variances with Negative Numbers
How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%. IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers. In…
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…
