-
Formula is not persisting when value is removed from cell
Hello, We are having an issue with cell formulas. The cell formula is erased when we change or delete a value in a cell. Here is the formula we are using: =IF(Status4 = "Complete", "In Progress") The formula should first check the cell status in Row 4, then change the cell status on the row where the connected cell is…
-
INDEX/Collect function with two criteria returns #invalid value sometimes...
Hi There, I have a status update sheet that has many columns. The three relevant here are: 1) Date Column = {createdDate} 2) Checkbox = {PSR} 3) free text column = {Overall Commentary} ----- In another sheet I am trying to collect the row with both the latest date and has the checkbox ticked. Here is my formula:…
-
How to edit a template
Hi everyone I have a template saved in a workspace but can't see how I can edit this - can anyone help please? Thanks! DW
-
Transfer Sheet Ownership
Hi, How do I transfer sheet ownership to someone outside my organisation. It has datamesh tied to it so not a fan of recreating it on the other user end.
-
COUNTIFS(OR - Count the number of rows with a checkbox in column A, B, or C
Trying to count how many rows have a checkbox checked in column A, B, OR C. The result should be 4 (Row 1, 3, 4, and 6), but I can only get the formula to work if all 3 checkboxes (A, B, and C) are checked.
-
Conditional Sheet Population
Is it possible to use conditional formatting or formulas to suppress unnecessary tasks? And, if so, could Smartsheet adjust dependencies for removed tasks? For instance, we have a sheet to track product implementations; however, some products are not elected by a client and therefore we do not have to track their related…
-
Averageif function looking at a list criteria
I am trying to create an averagif formula that looks at a list of values in a cell. Currently if I do it the normal way it just returns back if this specific value is the only thing in the cell. But once there are multiple items in the cell it doesn't count that within its result. Both formulas return the same way per what…
-
Expand/Collapse rows
Expand / Collapse all is not an option on my primary nor any of my parent rows. Why?
-
Is it possible to develop a task list from multiple source sheets through automation?
We are creating new courses and content for our LMS and we want to use a project sheet to track all the tasks associated with developing the course and its respective content from beginning to end. We have a handful of different "Learning Object" types that each have their own repeated tasks or activities to develop and…
-
Cross Sheet Joining Automation
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
