-
My main sheet shows read only
I'm facing a strange issue, i've created a mastersheet with around 5000rwos and 3500rows have data on it and those rows linked to another four sheets for particular data, now if i open my mastersheet it shows "we weren't able to load your sheet's cell links and had to make your sheet read only for now. sorry about the…
-
What's wrong with this formula?
=IF([% Complete]@row = 100, "Green", IF(AND [% Complete]@row > 70, [% Complete]@ row < 99), "Yellow", IF ([% Complete]@row < 70, "Red"))))
-
Formula IF|DATE|VLookup
What formula do you use to look at a date and if it is less than a specific date to include Vlookup formula in smartsheets? I am trying to write a formula in SS to review the Lead Create Date and if it is less than 05/01/24, than place "No Rebate" in column. If it is 05/01/24 or greater than follow VLookup formula. Error…
-
Calculate respective years based on start date and term
Hi, I'm looking to dynamically calculate and populate the year in the corresponding columns based on start date and the term length which is up to 5 years, so overall 6 years, including the current year and partial years. For example, for a July 1, 2025 start date and term of 48 months, I would like to see the years 2025,…
-
Lookup and Return a a the Unique Values
I have requirement to review the TYPE and return the Food value in unique list The outcome should like this written a formula like this like this =IFERROR(INDEX({Range of "Type"}, MATCH($[Food], {Range of Food}, 0)), "No Match") the outcome is coming like this. Only the 1st row is appearing and not the others
-
INDEX MATCH Formula with Cross Sheet References
Hello, I am trying to write an INDEX MATCH formula that will return a due date on my metric sheet while referencing a much larger projects sheet. Currently, my metric sheet has two columns: "Project Description" and "Initial Documentation / Broad Scope Due Date" Both of my project descriptions are identical - one is a cell…
-
How to Use Certain Contact Cells in a Column and Combine into One Cell
Hello, I have a project timeline/schedule where I want to take each 'different contact', in a column and combine them into a single cell so I can create a notification to the project team based on different tasks that change to 100% complete. My team uses a template for the timelines and I would like to set it up so we…
-
Cross-sheets sweep check
Hi, I'm trying to cross check if a any of the values (text) from Sheet B 'Value list' column is contained in the row (text string) under analysis in Sheet A 'Description', if found, I want to retrieve the corresponding row vale from Sheet B "Class" column and bring it to Sheet A 'Class' column. I can't figure out the best…
-
How to use automation to copy only certain rows to another sheet?
I have large rows of dataset in a sheet. I am looking for a solution that can copy specific rows to another sheet based on certain criteria. I used the automation template for copying rows, however, on fulfilling the condition specified, the automation all rows in the primary sheet to the secondary sheet. Is there a way I…
-
Storing historical Data
Hi Folks, I have a number column that is updated monthly and is overwritten with new values. However, I need some calculations based on previous data and current data in that column. For example - I want to calculate the deviation from the previous count to the new count. How is this achievable? Does Smartsheet have a…
