-
Trouble adding licenses
Hi, I need help… I am trying to purchase new licenses and am unable to do so. Please, if anyone can help me, I would greatly appreciate it. I follow all the steps recommended by support, but an error page appears, making the entire process unfeasible. The support team informed me that they would forward it to the technical…
-
Create a new row when a cell is updated in a report
I have a Report that pulls from a source sheet. When the data in the Report is updated, I would like it to create a new copy of the row in the source sheet rather than updating the existing one. Currently, since the Report is directly linked to the source sheet, any changes made in the Report overwrite the cells in the…
-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
-
Metric Sheet - Not updating with Automation Date
Hello everyone, For the past year or two, I've been using automation "Record Date" set to daily as a trigger for the cross sheet references on this metric sheet to update. As of recently, it stopped updating the references despite the automation running and updating the date. Was there a change that broke this? Thank you.
-
Is anyone available to assist me with why I cannot access my Smartsheets
I keep getting an error that I cannot access Smartsheets
-
formulas with percentage
I pulled in a number from another sheet, % Complete from Plan, that is a percent and want to subtract this from 100%. This is the formula I am using: But it renders #UNPARSEABLE
-
Add FORECAST Function/Formula
A Forecast function/formula would be incredibly helpful by increasing the value of the available data, and also its ability to be dynamic. My team has been looking for a solution to the lack of a Smartsheet forecast tool for years. This is the roadblock keeping us from exclusively using this program for all of our needs.
-
Is there a way to restrict unlicensed users from getting the pop up for a trial license?
We are trying to find a way to restrict this trial license pop up. The user groups within our company are setup on the admin side as un-licensed. We also have our domain list set up in SysAdmin as well. Not sure if there is any way to restrict this pop up?
-
Copy-Paste
Please add the functionality to copy and paste rows (from reports, sheets, or anywhere in Smartsheet) with their respective formatting, formulas, and validations, just like in Excel. Right now, Smartsheet only pastes the raw values, which forces us to export to Excel to preserve formats and then re-import. Having full…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…