-
IF statement with AND/OR
I am trying to create a formula that calculates Days Overdue based on varying approval levels. I need it to calculate if Direct Manager Approval is "Submitted" and Hiring Manager/Director Approval is blank OR if Direct Manager Approval is "Approved" and Hiring Manager/Director Approval is "Submitted". Here is what I came…
-
Sum Network days but if field is blank results show invalid data type
The subject pretty well tells it all, I am trying to sum the network days between the request received and request sent date but if we haven't sent the request response as yet the field is empty and shows the error " Invalid data type" Current sum is =NETWORKDAYS([Quote Request Recieved]198, [Quote Sent Date]198) Can…
-
Weeks to go Formula
Apologies if this exists somewhere - I tried to look but couldn't find exactly what I needed. Using smartsheet to project manage for an event - I am wanting to have a 'Weeks to Go' Column that counts down how many weeks until the exact event date along each task item. Thanks!
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
If cells in formula are blank, then leave the formula cell blank
I have three main columns: Planned Start Date, Planned End Date, and Date Completed I am utilizing the formula below to determine which tasks are done and late in the status column. I would also like the status cell to be empty if the date completed cell is empty. How can I do that? For some reason ISBLANK isn't working…
-
Formula To mark a row as recent
Hello, I would like to type the word recent into a cell based on it being recent(created date is in the last 7/ days). Otherwise I want the Cell to be blank. This is what I tried but get #UNPARSEABLE =IF([Created]246>=TODAY(-7), "Recent", false) I'm working in a quotes sheet that can get very long and I want to create a…
-
sumif with children and checkboxes
I'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variations of the formula I get everything back as #UNPARSEABLE I appreciate any help you can…
-
Time Formula - Drop Down Selection
Hello, I've searched and it appears the time formula is an ongoing battle for enhancement requests. Looking for some help, I have two columns; 'Start Time:' and 'End Time'. There is a drop-down box on the web form and sheet that starts at 12:00 AM and ends at 11:55 PM, all increments of 5 minutes. For example, 12:00 AM,…
-
Forms
I need data to land in particular areas when entering into a Form... In my sheet I have Hierarchy's...Months, Jan through December. Under those sections I need the orders that are entered into a form to automatically be put under each area according to the date...thoughts??
-
Formula to auto fill date based on last non blank
I figured out the formula to give me exactly what I need in Excel: =IF(LOOKUP(2,1/(A1:D1<>""),A1:D1),EOMONTH(LOOKUP(2,1/(A1:D1<>""),A1:D1),3)) This formula does not translate to smartsheet. I need a formula that finds the last non blank in the row and auto fills a due date of 3 months later, last day of the month.