-
Smartsheet Forms - Displaying View Only Fields
We have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those fields to be View Only on the Form (PM, Project Nm and Curr Go-Live Date). I haven't…
-
Sheet summaries OVERALL average
I was able to resolve a #DIVIDE BY ZERO Error message by using this formula =IFERROR(COUNTIFS(I:I, 1, C:C, 1) / COUNT(Hinge:Hinge), 0). However, I am currently hitting a road block on getting an accurate average from my sheet summaries. Is there a way to get an average of all summaries not labeled OVERALL that will only…
-
Have there been updates to automation?
I've noticed recently that automation doesn't seem to be working... have there been any updates/changes recently? A basic workflow to update a cell value is not working: This workflow has been working without fail for nearly a year, and now all of a sudden, the cell value is not being updated. I cannot say how long this…
-
Is it possible to query the URL's of sheets to table?
Hi there, I am trying to update some references on a roll up sheet and would like to quickly get the URL's of some key project artifacts. I'm not sure if there's a SQL type function in Smartsheet that would let me quickly let me get this data across all our workspaces. For example, I'd like to find all my Project Budget's…
-
Decimals keep changing
I have a dropdown column that we used for style numbers. They might be numerical values or alpha/numeric values. The column has always show the value that was selected in the dropdown as it should until the last week or so decimals are being added. No matter how many times I remove the decimals from the column when new…
-
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
-
Dropdown box Data in formula
Hello all, and thank you in advance for any help that you can provide. I am using a dropdown box, single selection, to select a date that determines data pulled from a table. I have 10 data values for each date in the table. I am attempting to use VLOOKUP to collect the data with the date from the dropdown box as the…
-
Countif Formula based on Column
I am looking to find a formula that will count if it is a quarter column. My sheet has columns - Fiscal Year, Quarter 2/3 (etc.) and then Monthly breakdowns. FY1 Total | Q1 Total | Jan | Feb | Mar | Q2 Total | Apr | May ... And continues on for a couple of FY. I want to get a count of how many quarters have a value in it.…
-
Using the average and standard dev formula
I am trying to use an average formula to get the average of data from the past 30 days. I tried using collect but seem not to be working as it gives me an error. I also am using standard dev formula both for the past 30 days/data before that row. Please help.
