-
Formulas to durations or equivalent
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I am wanting the variables to be as follows: Completion Date - Constant (fixed) Variable…
-
Adding Sheets to Sight
Hey, I'm not having much luck adding rows to my sights. I tried adding a widget with both "Metric" or "Sheet Data" but both add the rows in a list format. How do I add the rows to the sight as is, in their existing format?
-
Roll up Sheets
I have multiple sheets from different workspaces that need to be rolled into one sheet. What would be the best way for doing this?
-
Comparing 2 date fields and setting symbol
Hi. Just getting to grips with Smartsheet. I have pairs of date fields: Forecast Date and Actual Date. I would like to set a red status symbol if the Actual Date is past/older than the Forecast date. How can I do this? Alternatively I can set a check box if setting a symbol is not possible.
-
Case-sensitivity in filters on text fields
Hi, Does anyone know if there’s a way to do this currently, as it seems to be stumping me. E.g. I have 2 rows with “ERF_” in one column in one row and “erf_” in the same column in the other. When I filter on that column, I get the same result whether I use “erf_” or “ERF_”; i.e. both rows are returned. This seems to imply…
-
Update request triggering SmartSheets update Zap
Hi, I’ve recently come across a situation where this would be very handy; i.e. when you make an Update Request on a sheet, it could trigger a Zap. It seems to be currently not the case, unfortunately. Is this on the product roadmap at all? Regards, GAM
-
Beta of New UI?
Is there any way to get a beta view of the new UI? Just encountering UI issues while working in currnet view. Small things like makin the tabs smaller or multi row. Using more of the screen etc. I saw the new release will have many of my concerns addressed. But really wondering how to get on the inside track of beta views…
-
Formula - Multiple IF rules
I have the following formula working fine! In short, based on the value of the “Application/Product” value, I auto populate the value of a Contact column. =IF([Application/Product]1 = "Edits", "Jane Smith", IF([Application/Product]1 = "Scripts", "John Doe", IF([Application/Product]1 = "Matrix", "Billy Bob",…
-
Random ODBC Errors AND SSIS Errors Saying Sheets doesn't Exist
Hi There I use Smart Sheet 32 bit ODBC component to connect to SmartSheet and pull data to SQL server. Suddenly I see errors randomly. There has been a random error appearing each time the SSIS package is run (SSIS package uses ODBC provided by Smarsheet), it is not stable with one sheet missing error. Each time the…
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
