-
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…
-
New to SmartSheet - 2 questions on functionality
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan
-
Automations to move rows to another sheet is moving more than requested
Hello Smartsheet Community, I have created an automation to move rows over to another sheet when a certain phase and date are triggered. This automation is currently moving over those rows, but other rows in addition to the ones it is requesting. These other rows shouldn't be moved at all as the phase is not listed as one…
-
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…
-
管理者権限を付与できません
システム管理者のユーザーを、管理者権限でワークスペースに招待したのですが、閲覧者となりシートの編集を行うことができません。 ユーザー管理画面のトゥルーアップ画面では、「メンバー」の表記なのですが、シートを開いた際に「閲覧者」としてダウングレードされたと表示されます。 考えられる原因と解決方法について教えていただけませんでしょうか。
-
Change/CRAID Log Association to Project Plan Task
I'm using my Change Log as an example, but applicable to other sheets. I've manually copied the Project Plan Task ID, Project Plan Task Name, Role and Assigned To fields from my Project Plan into the Change Log. Within the Change Log I've simply made a few example requests. The relationship to any change request to the…
-
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…
-
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?