-
Merged: Dynamically Update Column References
This discussion has been merged.
-
Sheet Relationship Diagram
Is there a report I can create that will identify and map out all of the sheets that are linked to other sheets? We have hundreds of sheets, and quite a few workspaces. We regularly link one sheet to another so they all stay updated, but it can be hard to capture where everything is linked. For example, we have a resources…
-
Calculating average on linked cells - divide by zero error
I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells are not showing 0 in their calculation. I'm at a loss. My project plan showing the linked cells and avg formula. I'm…
-
Merged: Collapsed Data Source
This discussion has been merged.
-
Divide by Zero error when averaging 2 linked cells
I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells are not showing 0 in their calculation. I'm at a loss. Can someone help me with this error or explain why this error is…
-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
-
Date Formula Issues, Metric sheet
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well? I've tried a few…
-
Copying rows to new sheets based on multiple selections in one column
Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch and teach us something new. We need to keep a record of these sessions and who attended them. I have set up a sheet where I…
-
Update completed date on different sheet after form submission
Hello All, I have a form collecting construction progress updates. When a from is submitted, I would like the "Construction Report" on a separate sheet to have a completed date (equal to submission date on the form) entered automatically. We can assume that the forms will be submitted and kept in sequential order. I have…
-
Bring in data to new sheet
Below is a screenshot of the target sheet cell (Created on : etc) I want to update automatically when the source sheet is changed We currently have a cell link, but this is not updating without removing the cell link and redoing it each time. Here is the source sheet screenshot: