-
Ability to Find & Replace text in Formulas
Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
-
#Incorrect Argument Set
Hello, I am having issues with a formula and am hoping that someone can help. I am trying to tie two separate columns (Project Percentage and Days Remaining) to automate a project status column. I am getting an incorrect argument set error. Not Started = Project percentage is 0% Complete = Project percentage is 100% On…
-
Compare data from two sheets
Hello Team, I would like to know if it is possible to use the Automation in Smartsheet to compare the data in two sheets. Basically we use Smartsheet to manage devices and we have 2 sheets, one for Production devices and one for Lab devices. Since we manage a large number of devices, we need to find a way to continuously…
-
Inventory Check In/Check Out with Forms
Hey Everyone, I'm looking for how to automate a check in/check out process utilizing forms. What I want: Tech fills out form with the item's serial number and checks a box for if they're checking in or checking out This creates a new row in a helper sheet (CHECK OUT) A master inventory sheet (EQUIPMENT) update's the…
-
How to calculate NPS Score from Smartsheet Sheet
Hello, I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here? I've tried this formula (NPS Score 1): And this one (NPS Score 2):
-
Column Formula to populate a Helper Column
EDIT: I just realized this is listed in the Add Ons and Integrations section rather than elsewhere, but I cannot move it. I have created separate helper columns to return the value in [Plan Start Helper] for any of the matching [Opp #] where [Plan] contains the word "Plan" (I have other helper columns that need to search…
-
can i auto-populate/create rows on another sheet if a cell on another sheet changes?
In this case, I'll populate a scheduling sheet as seen on top, this will then ideally show up on the 18th of Dec (if it's scheduled on the 18th) as separate rows if possible. Not sure if smartsheet is able to do something like this so would like to get possible help or input? So far i've tried using smth like…
-
Formula for Cross-Sheet References Based on Row/Task Information
Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use template? To give an example of what I'm trying to do: I have a set of projects that are fairly consistent as far as activities.…
-
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
