-
How do I populate one field fromt he results of another
Hi there I am trying to create a purchase order system to work with our Programme manager (which is all in Smartsheet) Currently we use excel to create a purchase order then print it as a PDF. We then combine the PO with a quote from the supplier in Nitro. What I am looking for is a way to use smartsheet such that we have…
-
Gantt Chart Display
Does anyone know if there is a way to display the children (multiple) under a single parent in the Gantt Chart? I have a chart with several children per parent and would like to display them all under their respective parent. Each child has a set of start and end dates; the end of one child is not the start of the next…
-
symbol column to add workdays in formula
Hi, I want to create a RYG status if a date is late. If it is one workday late it is "Yellow", if it is 2 days late it is "Red" and all other are "Green". The End Date is the due date. The underlined formula will show 2 calendar days but I need workdays/vacation included. Any ideas on how to resolve?…
-
Formula help
I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1. Example: Cell A1 = "Sent w Statement" Cell B1 = $100.00 I need C1 to populate $100.00 because A1 has the word Sent within the text Any assistance is greatly…
-
Help with Sumif not recognizing criteria as a percentage
Hi all, Trying to create a field that will tell me what percent of a list of values have exceeded 80%. =SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[80% Value Forumula Use]7) Goal progress is a percent value i.e. 100% or 45% 80% Value is the number 1 Smartsheet is not…
-
Moving Massive Qty of Rows
Good Afternoon, I'm currently dealing with a minor issue with SS while moving rows. Once a month, we move a single months worth of data from our main Completed sheet to an Archive sheet I have created, to keep record of previous rows that have been marked complete past 3 months. I do this to keep the loading time down in…
-
How to push fields closer together or hide label field in webform?
We've created a webform which has a couple of multiple selection questions. We used the make them all from check boxes field types with the label to the right but we want an additional field below for free typing feedback. The problem is the free type field at the end of the list is it looks out of place having a label of…
-
Nested If Statement
I have been struggling for a long time trying to get a formula to work for me. Here's the issue... I have two IF statements that work fine independently of each other, but when I combine them I keep getting an 'incorrect argument set' error. Here is the formula, and if someone could help me out with this I would be very…
-
countIf for several values in same column
Hi - Newbie here, but how do you count several text values in the same column? =COUNTIF(Status:Status, "Closed" OR "Deployed") doesn't work
-
Only part of the formula working ? Top Half
=IF(SUMIFS([Value of Jobs]25, [Assign Too]25, "Heath Sanders", Status25, "WON", Result25, 1, [Sold Date]25, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]25, IFERROR(YEAR(@cell), "-") = YEAR(TODAY())) = 0, "", SUMIFS([Value of Jobs]25, [Assign Too]25, "Heath Sanders", Status25, "WON", Result25, 1, [Sold Date]25,…
