-
Summing up just the parents
want to do a summary field on a smartsheet that has a month for each parent and the children are transactions under each month they occur. each parent has a column (same column as the children) that has a total for the children. Without adding new columns to designate this is a parent, this is a child. Is there a formula…
-
Minimum of a certain range
Hello, I'm trying to use a formula to find the oldest date for a certain range of rows. Is there a similar MIN function as there is to SUMIF or COUNTIF? Or some similar work around? This is my attempt, but it does not work: =MIN(IF({PM Sheet Region} = "TQM", {Column of Dates Here}))
-
Duplicates from Excel
Hey Guys! I am wanting to count duplicates from a dump in Excel for one column (Supplier Id). I know my formula is correct but it seems to not be counting correctly because either 1) the tick mark added to the beginning of the number from Excel or 2) the amount of zeros? Any ideas to fix this? Formula: =COUNTIFS([Supplier…
-
View By Drop Down - Card View
How can I add conditions to the ' View By" drop down in card view. In the demonstration it shows multiple including " assigned to, progress etc" . Mine only gives options for two- progress and priority.
-
How can I do an IF Statement with Years
Hello, I have been trying to find an answer to my problem through the forums but have been unable to solve it myself currently. What I am trying to do is set up a formula that tells us when employees get vacation days. How our company currently works is as follows: If employee has been here 1 year, they get 5 days vacation…
-
Status change formula using IF function
I have a status column that I would like to set up a formula in to do two things a) Change status to "Needs Update" when a date in a date column is reached b) Change status to "Prequalified" when three checkbox columns are all chacked Here is the formula I have so far: =IF([Expiration Date]@row = TODAY(), "Needs Update",…
-
Simple IF function not working
Hello, I have an issue with a simple IF formula. Here's the formula: =IF(Completion1 = "100%", "Closed", "Open") for Overall Progress Column. It's not working. Even if the value is NOT equals to "100%", the value showing is the false one (Open). I don't know why it's not working. A note: The logical expression (Completion…
-
IF Formula using date cells with formulas
Hi, Im new in smartsheet and im currently trying to compare a Task Limit Date (for completion) with Today's date to determine if the Task is Late or On track My formula is the following: =IF(Limitdate@row > TODAY(), "Late", "On Track") As my Task Limit Date was initially documented in quarters of every year, for example;…
-
Multiple IF/AND statements
Hello, Trying to combine the following formulas based on changing criteria and not sure how to put them together. Each one works on it's own but as soon as I try to add another one I get an #UNPARSABLE error. IF(AND([Vendor Assignment]@row <> "", [Window End]@row = ""), "Vendor Assigned", "") IF(AND([Vendor Assignment]@row…
-
If Statement Plus Index(Match()
Hello Again Smartsheet Community, Hoping to get some help with this one. The project I am working on is essentially a group of people will submit a request, based on the submitter they will be assigned to Group 1, 2 or 3. Depending on the group there will be one of several people available to process their request. The…