Formulas

I have a sheet that has one column that I am needing to total . The formula consist of only 3 cells in the column but it is only adding one cell in the total. Any suggestions?

I'm looking for an IF/COUNTIF formula for automatically flagging the flag symbol column when a contact's name appears in a Contact column for a 3rd time? (incident tracking report)

Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that has linked in RYG balls for health from another sheet. There are three sections, with…

Hi, I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great. BUT.... It now red flags every row that doesn't have a date in yes which is an issue as we are using a project…

I currently have a sheet with Smartsheet Licensed Users in our company, we want to check the last time each user logged in to Smartsheet so that if we think they do not require a license we can remove it from their account. I currently do this by generating a User List Report in the User Management section of the Admin…

Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet. Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeepers that work on the project. Normally I would use Index Match however, some clients…

When i reference the VLOOKUP fields in the COUNTIFS formula, I get this error #NO MATCH. =COUNTIFS([Server Install Status]:[Server Install Status], "Installed", [In Scope]:[In Scope], "Yes") The [Server Install Status] column is populated with the results of =VLOOKUP([Server Name]1, {cmdb_ci_win_server20200810 Range 1}, 3,…

I need a way to count the number of states each project participates in. For example, for Project A I should be able to says West Va and Va. Smartsheet will not allow me to count the state column. So I would then like to be able to separate each project by row based on the state column. I found VBA code to use in Excel to…

Please help, what's wrong? It couldn't be parsed... =IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ") Thank you in advance.

I have found a key element of Program Management that needs solution in the Smartsheet platform. The calculation for IRR is critical component and not available as general function. As you may know, this simple one varying net cash flow typical program. Does anyone calculating real-life program can share with me?.