-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
Quoting tool
I am trying to create a quoting tool for our fencing company. I need to add # of products + pricing and have a data field on the quoting form that calculates the total. Example: 50 Ft of fence at $10 = $500. Can i get that to calculate on the form? Trying to create a final quoting page to give customer. how do i do that?
-
From End Date Calculate Start Date
a date function that start with the "due" date(end date) and total hours to calculate the start date
-
Metric Widget data source from a report
A report is not available to be a data source for a Metric Widget. I have a report that shows the one figure I want to be displayed on a dashboard. I cannot convert the report to a sheet and cannot seem to get the report number on my report to the Metric Widget… Can this functionality be added to use a report for a data…
-
Cell value for main or subworkflows.
I am trying to create a formula or workflow that changes a cell value to a value in another cell. I tried with workflow, but I can only assign a text or specific value from a drop down. But I want to assign a value from a specific cell. Formula would help, but this then needs to change depending if the cell is already…
-
In Smartsheet, how do I lookup and return different values from sheet 1 to Sheet 2 in one cell?
Hello, In Smartsheet, if I want lookup and return different values from sheet 1 (Test-IMS) to Sheet 2 (Test 2-SOS) in one cell, what should I use? Note: The two values from Sheet 1 will be different. Let me know if you have questions or I need to clarify more. Thanks,
-
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
-
Filtering for Linked Cells
I am trying to run a report for all of the cells in my "Last Contact Date" column that are not linked to another cell. We have separate teams who are populating separate sheets (SS Logs) so we can link the dates back here, but until they do, we'll just see the dot indicating it's linked with a blank value. The full sheet…
-
Filtering by Cell Links
In our workflow, we rely on cell links to populate data from separate team sheets (SS Logs) into a master sheet. Currently, when filtering our linked "Last Contact Date" column for blanks, the filter includes: Cells that are blank and not linked Cells that are linked and the source cell is blank This makes it difficult to…
-
Table View Matching
I'm doing a column match in table view. Here's the results I got: When Source Sheet primary column is a calculation = No Match 2. When Source Sheet primary column is manually typed = Match Nothing else is different, is this a limitation that you can't match on a calculated field? The column types are both Text/Number.