-
Formula to combine data from another sheet
I just had surgery and I am trying to keep track of my medicine inventory. So I created an inventory log of my medicine and I have it split into 4 columns as I want to keep track of each medicine so that when I am running low I can ask for a refill. So I have two sheets. Medication Count Management Medication Management I…
-
Smartsheet FORM Dropdown List - Cells in Column "have values that aren't dropdown values" Error
Hello All, Specifically for the Form's Dropdown List - what does it mean when I get this error message for a list that has 87 (manual, ugh) entries? —> (14 cells in (form) column) "have values that aren't dropdown values." Are there any special characters that aren't allowed, maybe? What are the rules for text to be valid…
-
Workflow not triggered when a new row is added.
Hello - I created a workflow, to ensure that anytime a new row is added, it will by default, check the "Show on Report" field, which is unchecked by default currently. -The trigger is "When a new row is added" and Run "When Triggered" However, I have added a number of rows as a test over the past hour and it hasn't checked…
-
I want the total count from 2 sheets from a column with multiple leads
When I created the first formula it worked, when I add the second one linked to another sheet I get the nested criteria error. Even when I remove the extra end parenthesis still an error. Separately these both work together it doesn't work
-
Setting checkbox as true based on conditions of multiple columns
Hi! I am trying to set a formula that will check a checkbox based on conditions of multiple columns. This is the formula that I am trying to use: =IF((COUNTIFS([PMO: Contract requirements review]24:[PMO: Is customer source inspection required?]24, "complete")+countifs([PMO: Contract requirements review]24:[PMO: Is customer…
-
Formula Creation & Random Changes
Hi All, I'm building a reference Sheet off of a 'Master' Smartsheet in order to create a Dashboard for some KPI type tracking. I'm pretty OK with formulas, the main ones I'm using here are simple =SUMIFS() and -COUNTIFS() Example: =SUMIFS({TYS Master Data - From SFDC Range 1}, {TYS Master Data - From SFDC Range 3},…
-
Multi-factor Authentication
In order to mitigate password vulnerabilities and attacks, please add multi-factor authentication to Smartsheet. It's a security best practice and most SaaS applications (such as Smartsheet) already has this integration available.
-
Conditions
How do I stop an email from being generated from a condition in one cell that is sent out after it passes a certain day? I want the emails to stop when a condition is met in a different cell.
-
Automatic Backups no longer have link to download
Is anyone else having a problem with automated workspace backups? The email used to contain a link to download the backup in zip format. Now the link just goes to a blank page. /marc
-
Help With Using LARGE in a Date Modified Column
Does anyone have experience with using LARGE in a formula to return results with latest Date Modified? I am needing to return a string that ends in the date & time a contract is marked as complete. In this instance I am looking to return a string for the 5th newest contract completion date (I am compiling the top 5 if that…
