-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
-
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",…
