Formulas
Discussion List
-
General Update on Assignments formula with Today - xIn Formulas and FunctionsHi all, as you may be all aware, I'm definitely not the most versed in the formulas when it comes to Smartsheets. I'm a self-study without any prior experience and I did learn a lot and can address the majority of issues myself, being than…
-
Created Date Formula for FormsIn Formulas and FunctionsIs there a formula that will capture the created date for new entries on a form? Once the form is completed, I would like a column to automatically populate the day that row was added from the form so I can track response times. Is there…
-
How can I rollup a sum using an id in two separate sheets?In Using SmartsheetI have one sheet, the Purchasing Request sheet, which tracks a single request made. The ID column serves as a primary key here. On the other sheet, I have items that are tracked and related to a given request. The ID column in this sheet …
-
Need help to adjust automatically my Order Date using Date FormulaIn Formulas and FunctionsHi, I have two date columns in my sheet 1st column is "First Order Date" and the next one is the "Next Order Date" with underlying formula of =[First Order Date]@row+ 30, we need to supply our clients every 30 days. Th…Answered - Pending Review 11 views 2 comments 0 points Most recent by Leibel S Formulas and Functions
-
Formula to reference two values to return a third?In Formulas and FunctionsHello everyone, Hoping someone can help. I am wanting to create a formula that, based on existing criteria in two cells, will dynamically return the value in a third cell. From my "Aggregator/Calculator" grid (screenshot below), …
-
Automate the Progress BarIn Formulas and FunctionsHi there Smartsheet Guru's! Im trying to figure out the best way to automate a progress bar, based of 9 columns that all have check boxes. Screenshot shown:
-
Extract Image using Index and Match/VlookupIn Formulas and FunctionsHey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…
-
formula not working on row1In Formulas and FunctionsHi , Can anyone help why the formulas are not working on row1.I mean i am not able to use any formula on row1 ThanksAnswered - Pending Review 11 views 3 comments 0 points Most recent by Finops C'ship Formulas and Functions
-
Weekly progress report - project relatedIn Using SmartsheetHi , Need a help of team. complex one :- I have Project Plan sheet for following data below screenshot 1 I want to create a report based on status and weekly progress % Complete as shown in Screen 2 to create a dashboard chart as shown in …
-
Number of day to complete less weekendsIn Formulas and FunctionsI am currently using the formula below to calculate the number of days to complete a task. Is there a way to exclude weekends. (option 1), and possibly a custom list of holidays (option 2)? =[Resolved Date]@row - [Created Date]@rowAnswered - Pending Review 1 view 1 comment 0 points Most recent by prathap.krishnashetty69881 Formulas and Functions
