-
Help on Formula: if function
Hi all, Please need your help. I'm new to formulas and I've been trying to figure out the right formula for my project status and progress report but I kept getting errors. I have tried the below formula in excel and it worked but not in smartsheet (the smartsheet formula below is another trial I did that did not work).…
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Help on formula: Countifs with multiple columns and criteria
Hi, So I've been working on a formula but couldn't get it right. I wanted to count the number of my projects that are Active (on-time) and Active (delayed). I get the on-time count correctly but for the delayed ones I always get a plus 1 in the results. Here's the formula I use (btw the stages represents that a project is…
-
Finding the latest date of certain tasks based of those tasks' attributes
Hello, I'm looking to find the latest end date for certain tasks based off of attributes in those tasks' rows. For example: If I want to find the latest date of tasks in cycle 1 of a release (but not cycle 2), and within that there are 5 different categories of tasks but I only want to know the latest end date of one of…
-
IF Statements and Linking Sheets by Ranges
Hi, I am working on a project creating a weekly sheet for distribution where one week of info is pulled from a range of data on a separate 13-week sheet. Basically, on the weekly sheet, I am using IF() statements to search a cell on the 13-week sheet for text. If the cell contains the proper text, the name from that row on…
-
Highlight Colours
Hello, I have an 'Alerts & Actions' when a row is added to email out many cells. When this email arrives in my staffs inbox the cells are bright yellow. Is there a way to change the colour? - I would ideally like a less bright colour? Any help would be wonderful. Thanks Matt
-
Help on formula: Nested ifs
Hi, Please need your help on the below formula. As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to close the project at a certain stage (these are the subtasks) because of any of the listed reasons, it will be reflected in…
-
Formula for projects due to start in X no. of days
Hi again, Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Set" error. Please don't get confused with the formula. The projects I created have 5 subtasks and as an alternative solution,…