Formulas

Hello, I'm trying to create a formula to flag if a start/end date is in the past and the started/complete checkboxes haven't been ticked. I have conditional formatting to show this but I want to count how many red flags I have across my sheet and I understand I can't use formulas to count conditional formatting, but I can…

Hi, Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists. Item # | Item Requested | Priority 21 | Test 1 | 1 23 | Test 2 | 2 24 | Test | 3 25 | Test | ---here the number should auto-populate as…

Hi Community, I am trying to make a work flow that moves a row when the Latest Claim Status is Denied. However, I only want the row to move once all the columns are filled in for that row. I don't want any specific cell to be the trigger as the information might not be filled out in column order and I don't want the row to…

Hello Community, I am hoping someone has a suggestion for my issue. I searched the previously asked questions and couldn't seem to find it. Ultimately, I am trying to maintain one master sheet of data that populates secondary filtered sheets based on their "Area of Expertise". I realize I can do this using the reporting…

I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is "active"). I've tried 100's of permutations of SUMIF and SUMIFS and each time is either…

Hi, I am working on building construction scheduling. In the template of my schedule, I have a list of items with predecessors. My questions, once I marked one item as N/A or DONE(two separate check boxes), how can I make the following items that have relation to this item to catch up? For example. let's say item A was on…

I want to flip a column which will be last, first names and return first last. So Doe, John becomes John Doe I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is not helpful. Last Name Formula: =LEFT(NAME31, FIND(",", NAME31) - 1) First Name…

Is there a way to take a column: Last, First and build Firstname.lastname@mycompany.com Scenario: I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no control over the original spreadsheet, (so cannot have the sender manipulate the data in…

I'm trying to sum a total using two criteria and it won't work. I can do the sumif for each criteria seperately but when I try to do the "ifs" one to combine the criteria it says "unparseable". I have these fields in one sheet and trying to sum them in a separate sheet: Month/Year Manager (as a Contact field but I don't…

Hi, We have been using SmartSheet for many years and have developed our entire project management around it. Every production sheet is derived from the same template. Thus, every production sheet has the same columns and many of those columns have formulas. These sheets now use summary fields, some of which derive their…