-
Merged: Editable column formulas
This discussion has been merged.
-
We have two forms where data is being submitted but it is not transferring to the Smartsheet grid.
Something is amiss. We have received submissions from two Smartsheets where the data is not transferring. One sheet has 14 submissions and the other has 18 submissions. Where's the data? Is it lost for good or is it just out there in the data sphere looking for a place to go? This is the first time that we have encountered…
-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
-
How can I capture the date and time of specific column changes?
I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action after that for cycle time purposes. Currently, I can track cycle time for dates but some actions need to be carried out within…
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
-
Templated Sheets and Dashboards
Hello! I have been trying to do some research into this and all of the previous questioned posted were all from some time ago (3,4 years!) so I wanted to revisit the question. I am working on a means to create a templated sheet that is automatically tied to a dashboard that does not require someone to manually switch the…
-
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Is a cell value driven cross sheet formula possible?
Our projects have a subfolder with any number of sheets that all have the same data layout. We need a summary sheet that fetches a status value from each child sheet, but i can't figure out how to do it in a way that wouldn't take 90 hours of tedious work - that would need to be repeated forever and ever In excel i'd use…
