Formulas

StartTime: 11:00 Column 02 ==> EndTime: 12:45 Column 03 ==> Hours: 1,75 Thank you ","categoryID":318,"dateInserted":"2016-03-17T15:20:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-02T14:54:40+00:00","insertUserID":5795,"insertUser":{"userID":5795,"name":"Dominic Chan","url":"https:\/\/community.smartsheet.com\/profile\/Dominic%20Chan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-05-20T19:31:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":29051,"lastUser":{"userID":29051,"name":"Jemmarie","url":"https:\/\/community.smartsheet.com\/profile\/Jemmarie","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uwVbJ0A0n2Q!Wo_an3gmWnw!_tgyZhX4PRy","dateLastActive":"2023-08-04T08:52:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":2829,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/4521\/hours-calculation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4521\/hours-calculation","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":20546,"type":"discussion","name":"#REF in Predecessors","excerpt":"What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window? I can't figure out what to do with them. I searched the Help Center and they say that #REF means \"The formula references a cell which does not exist, possibly due to a row\/column deletion.\" but this is not in a formula so I can't…","categoryID":322,"dateInserted":"2018-03-02T11:32:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-02T13:21:56+00:00","insertUserID":37316,"insertUser":{"userID":37316,"name":"Veronica de Capileira","url":"https:\/\/community.smartsheet.com\/profile\/Veronica%20de%20Capileira","photoUrl":"https:\/\/lh3.googleusercontent.com\/-DEFBX0Gd6ZA\/AAAAAAAAAAI\/AAAAAAAAAAA\/AAnnY7roCz_F_lSu21FzcSBQottCSmmnLA\/mo\/photo.jpg","dateLastActive":"2021-11-11T19:35:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":12305,"lastUser":{"userID":12305,"name":"Jayam Nagesh1","url":"https:\/\/community.smartsheet.com\/profile\/Jayam%20Nagesh1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-07T20:02:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":2705,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/20546\/ref-in-predecessors","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20546\/ref-in-predecessors","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/bc\/59\/bc59497de69b23fbbaa9c650d6c1048b.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-03-02 at 11.31.32 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
Best way to report a top of funnel of requests metric
Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
COUNTIF FORMULA ERROR
Hi all, I'm fairly new to Smarthsheet and have run into a simple COUNTIF formula error. I want to simply sum all cells in a column that contain the text "*C-000*". My formula is below and I don't show an error in the formula but I also have zero results where I should be showing a sum total of at least 26.…
COUNTIF or IF Statement
I am looking to add date columns that are based on a criteria in another cell. I can use the COUNTIF statement to add the dates but when I place an criteria in place I get an error. =COUNTIF([Due Date]:[Due Date], <=TODAY()) This works to count my dates that are less then or equal today but I need it also to filter out if…
IFS公式与过去,不完整d
Hi, Hoping I can get some assistance on a formula for to give me a count if the following is met: Count the # where: Type column is "Task" or "Sub-Task", Task Status column is "Not Started" or "In Progress" and End Date column is Today or In the Past I would like to not add any additional columns. Thanks!
=NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) returns 1 when date is the
Using formula as follows should return with a 0 if the dates are the same. Why is it returning a 1 instead? A similar formula if used in Excel will return a 0, so I would assume Smartsheets would do the same. Am I missing something in the formula? Thanks, Lawrence
Hours Calculation
Is there any way to calculate the difference between two differente times, like: Column 01 ==> StartTime: 11:00 Column 02 ==> EndTime: 12:45 Column 03 ==> Hours: 1,75 Thank you
#REF in Predecessors
What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window? I can't figure out what to do with them. I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't…

Formulas

Discussion List