-
Having trouble comparing two cells
I'm having some issue with comparing two cells in my Smartsheet. I want the box to be checked if the cells match, and if not, the value of the one on the left should turn red. I have 8 sheets for 8 different budget accounts that are all based on the same template. This works for every one of them except for this one. In…
-
Formulate % Complete for Stages on Dashboard
Overview: I have a sheet with a number of equipment items for my team to collect and log. The data is split into 3 stages. (Stage 1 = Sky blue, Stage 2 = Medium blue, Stage 3 = Grey) If the data has not yet been gathered the column with populate a 'N'. The project team will change the cell to 'Y' if field is complete, or…
-
Can I link 2 sheets with a formula that feeds many date columns?
Dear All, would you please advise if this is possible? if yes, would that be a combination of JOIN/ COLLECT/ IF / AND? If no, is there a way around it? I need the dates in these 10 columns: to feed into these 2 date columns: The condition is that Discovery Start Date has to feed into Phase Start Date when the activity is…
-
Struggling with COUNTIFS and CONTAINS
Hello! I have read through a bunch of questions about COUNTIF and CONTAINS formula but none seem to be working for me. I have a metric sheet in which I need to count the number of projects in a particular status for a particular business unit. The business unit field on the source sheet is a multi-select field, projects…
-
Multiselect column for each row return all associated matches from another sheet.
I have a convoluted problem, index match only works for single input, and I have a multiple select column for business unit with up to 6 options resulting in up to 6 individuals needing to populate the contact column from sheet 2 in the project tracker and unlike excel I cannot use wild cards. Sheet 1 Project Tracker sheet…
-
Formula guidance
Hi guys! I am trying to help fix a sheet that was built by someone else, and that person is no longer working for the company. They have a Dashboard that pulls data from a metrics sheet, that pulls data from a main data sheet. It looks to me like the sheet was moved or something, as it appears to have disconnected from the…
-
Need help dialing in a grading formula [percentage to letter (100 to A+, 80 to B-, etc.)]
Hey all, This formula works most of the time, but it won't show the letter grade all the time, I think when its close to an in-between number. Any help making it function 100% of the time and not show an empty cell would be appreciated =IF([Week 04/01 Results]5 > 0.96, "A+", IF(AND([Week 04/01 Results]5 >= 0.93, [Week…
-
Why won't my automation to record dates work?
I am trying to record a date for each of our statuses listed below. Approval Pending, Approved, Denied, In progress, Completed, and Removed Most of these statuses are updated by a formula when dependencies are met on my sheet. The formula for the statuses is working correctly, but for whatever reason the In progress,…
-
If the column you are trying to delete is used in a formula then you see a message
If the row or column I am trying to delete is used in another sheet or referenced in a formula within the same sheet then I want to see a message pop up saying the same. This will prevent other sheets, reports, dashboards from getting messed up without me having to manually track all my references.
-
Help converting an Excel formula to work in SS
I've inherited an Excel spreadsheet that is currently uploaded via DataShuttle into SS. However, I have to add six columns and formulas in Excel prior to completing the upload via DataShuttle (data is exported to Excel; six columns are added w/formulas; then DataShuttle moves it to SS). I can't figure out how to convert…
