-
Formula cell limit
Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
-
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
-
Workflow actions not being triggered by changing linked cell
I currently have 2 sheets, sheet 2 has dates cell-linked from sheet 1. In sheet 2 I wanted to use the "Change Cell Value" action whenever the linked date changes in the sheet to save "Yes" in a column called Date Change. However I see that even when the date changes the workflow is not being triggered. I have read that…
-
Is there a way to put a date row into a single cell on another sheet with the most current date?
I am trying to have a sheet that reports multiple sheets. I have merged cells and that works but I am looking to merge a whole row of dates to a single cell with the most current date featured.
-
How can I bring cell values from one sheet into another sheet "multiple values cell"?
Below is the source sheet destination sheet
-
Dynamic Data Validation with Columns from another Grid
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
-
Reducing intricacies that need multiple child sheets to 1 simple solution (datamesh bi-directional)
@Genevieve P. Please please please make it so that you can either do a "report from reports" or have data mesh work in both directions. That or make it so that dynamic view can have logic for which fields are shown based on which column the current user is in. This is necessary because sometimes a user will be listed as…
-
Automate Linked Cells
I have an issue that I've seen in other discussions but I have not been able to figure it out for my situation. I want to automate the process of linking cells from one smartsheet to others. I will provide as much information as possible below. - We have a master sheet, "Project Dashboard" with about 15 columns where I…
-
How can I tick a box based on two criteria?
I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them? =IF([Checkbox]@row = 1, 1,0) =IF([Task name]@row = "XYZ", 1,0)
-
Auto number risk column only adding till row 20 to another sheet reference
Dear reader, I came across a unique issue and need a help. I created a 'portfolio sheet' with list of projects in one column and a next column for Risk ID with text single line I created a separate sheet 'Risk register' with a dropdown of all the projects similar to the portfolio list and added a Risk ID column with #Auto…
