-
Adding in a cell via if then?
Hello Community, I need help with a formula. I would like to add the totals into one cell based on the following condition but don't know how to write the formula. For example, if the Status column, has any of the following results, then add the amount in the "Amount" column in this cell. Any help would be appreciated.
-
I need help to calculate the overall Priority by using IF condition.
Hi, I need to fill the Overall Priority column. I use IF statements to get the result, but not sure what's missing. Please help me with Formula. I have got the Priority columns data by forms, need to summerize of all priority columns in one column(Yellow Highlighted). for intance, Test Project should show "Low"(1) Test…
-
Metrics sheet - Want to use formula to pull in date when column type is "text/number"
Hello, and thanks so much for any support with functionality or a work around. I am creating a summary page for the system I am building. I would like the summary metrics to form a grid like table for visualizing sections of data. First column is the title and second column is the data. The column type for pulling in the…
-
If cell equals this, then insert cell
Hello, I am looking to auto populate a cell with some information pulled from another sheet. So if Site Name equals 'Bury', Contract ID should populate with '0004' from other sheet. I'm struggling to find the correct formula in order to do this, if somebody would be kind enough to help please.
-
Nested IF Formula
Hi Everyone I need to create a formula for a workflow status that shows a set % for a workflow stage when the Status column is updated. I.e: if the Status Column shows "In Progress" the Status % column automatically shows "20%". I've tried various nested IF(AND) and IF(OR) formulas but can't get them to work. This is what…
-
Stoplight formula help
Hi all... I've gotten some good help on this forum before, so hopefully you all can help me out. I'm trying to create a stoplight formula for tasks in a project plan. I would like to trigger colors of red, yellow, green based on the percentage complete of that task, and how far we are from the expected finish date of that…
-
INDEX/COLLECT criteria not pulling correct unique ID
Hi There, I'm at my wits end and have spent way too many hours on this already. I am trying to pull in a unique ID from another sheet using a matching date, zip code and county. Here is the formula and a screenshot example of results: =INDEX(COLLECT({2022 ID}, {2022 Event Date}, [Event Date]@row, {2022 Zip Code}, [Zip…
-
Index Collect Formula Showing #Invalid Value
I've been searching around and my formula looks correct. I even saw on a previous discussion that you should erase the formula and then log out and log back into Smartsheet and maybe that will help (unfortunately it didn't for me). I've also tried to make the formula manually multiple times. The only thing I can think of…
-
Automated Reminder for Approval Request?
Hello, Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the approval status is still "Submitted". I can't find where I can build a reminder based on the status change plus a number of…
-
Count Collect formula assistance needed
Hey all, I'm using a Count Collect formula I grabbed from the PMO template as a baseline. Here's the original formula: =COUNT(COLLECT({Task ID}, {Task Status}, "In Progress", {Task Health}, $Label@row)) Only thing I changed from the PMO is instead of "Project" I changed it to "Task". I'm trying to get similar metrics on…