-
Link across sheets
Hi everyone, New to Smartsheet formulas. I need a formula in another sheet to check {MJS1_InSo} for non blank, and copy {MJS1_TaskName}, if true, and a few more columns to the other sheet. Keeping in sync, both ways. Why is this formula not working? =IF(NOT(ISBLANK({MJS1_InSo})), {MJS1_TaskName}, ""). This is returning…
-
Looking to create a Auto Numbering System that is a little more advanced. [Help!]
Hey everyone! Looking to create a numbering system for Change order Generation for my company. Currently the Auto Numbering from smartsheet is a little simple for our uses. I'd like to come up with a formula that checks if any other change orders exsist for a given project number, then gives is a 1,2,3 after that. So the…
-
Formula on Project Plan
Hi, I have five stages on a project plan, parent row s, with numerous child tasks underneath. I want to have a formula that marks child tasks based on this formula: =IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS")) The parent rows also have this formula: =IF([%…
-
Counting two columns
Hi! I want to be able to count two columns next to each other (my subproject and task columns, which I use symbols to denote respectfully). I can figure out how to do the one column - =COUNT(CHILDREN([SUBPROJECT:]@row)) but can't figure out how to add on to my equation to also count my task column, which is called TASK:
-
Trying to use Vlookup and contain with specific word from another sheet
I can't seem this get this to work =IFERROR(VLOOKUP(Epic@row, {5.0.0_Project Range 1:{5.0.0_Project Range 5}, 5000)),false) I am trying to cross check another sheet and just lookup for only the specific tag that matches the firm column and with the subfix "RFE-"
-
Using CountIfs with an and condition summarizing data from sheet 1 to sheet 2
I have a sheet that list PC that has been deployed to a user at a given location The detail sheet has the suer location and a checkbox for when the PC has been deployed. On a summary sheet, I am tracking for each location, how many deployments were planned and how many have been completed. I am trying to use CountIfs abut…
-
Insert todays date on a project plan start date column
Hi, I use blueprint control center to replicate the templated project plan for every project that we approve. I want to automate the start of this project plan by entering the date it was created as the initial starting date for the first task. My plan is full of predecessors, so once the initial date is inserted in the…
-
Report does not display new sheet names
New user here. I have looked through the help but cannot find my specific question and hope to find help here. I ran a report summarizing specific content from various sheets and filtered the results based on which sheets and content to display. I updated all underlying files to sort them in a way I want them which also…
-
Count IFs or Sum IFS Formula
Hello all!! So currently trying to get a sheet summary formula to show the number of Dealer ID's that are not enrolled. Pretty much just need the number of Dealer ID's shown on the SS when the Enrolled Checkbox Column is not checked. There should be 162 Dealer ID's that are not checked but the formula I am using is…
-
Adding rows in existing sheet if multiple selections in a column exist
Hi Smartsheet-Community, I previously have been searching for a workflow which does the following: I'd like to achieve within one sheet that as soon as multiple assignees are selected from the respective dropdown list, one or more rows are automatically created below, which copies the content of the above row and splits…