-
Formula under Duration in a Gant chart
Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of resources to set the best outline. I would like to set the work (total effort to…
-
Vlookup a cell with a formula
Hello everyone, I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode the numbers instead of suing a formula, then the Vlookup works. Does this mean that…
-
Summing rows if columns are checked using cross-sheet reference
Hello, This is the formula I've tried but it is giving me an "unparseable" error. =SUMIF({Tracer Site List -Revenue/Project Complete},[Project Complete]:[Project Complete], 1, [Licensing Fee]:[Licensing Fee]) Thank you for your assistance!
-
Formula Help
Hello, I am trying to figure out a formula that would function as such: Column B will pull a data value from another Smartsheet based on the matching data point in Column A. Column A 123 Column B (Based on what is in column A, will insert data value XYZ from Other Smartsheet) Other Smartsheet Column A 123 Column B XYZ…
-
TotalFloat inconsistency between parent and child tasks
I am looking to utilize TotalFloat in a project plan and am finding inconsistent results with parent and children tasks. The sheet is set to Mon-Fri working days with no holidays set. The formula in use is =TOTALFLOAT([Task Name]@row) + " days" From what I am seeing: -The manually calculated delta between Line 14 and Line…
-
WORKDAY formula to prevent auto planning on weekend days
In my sheet I would like to use a date and add 3 days automatically in another cell, but I want to make sure the date that automatically appears is not on a Sunday or Saturday. I have looked in the Formula Sheet which is provided by Smartsheets, but can only find formulas which calculate the amount of workdays between two…
-
Formula to auto pupulate status column based on dates
Hello, I am trying to get the status column to populate based on date range. I have a Start and Finish date in each row and want it to do the following When Start date is < today, say "NOT STARTED" When Finish date is > today, say "COMPLETE" This third one is tricky - When Start date is < = today AND Finish date is > =…
-
Formula based off a selection
Hi All, Could really use some help on trying to figure out a possible formula for the below: There will be two options for freight provided, "COMPANY, and "eShipping". When "COMPANY" is selected the true cost will populate in our total cost column. When eShipping is selected I want cost *.10 to calculate in my total cost…
-
Conditional Formatting countdown that avoids Weekend Dates
Hi all! Long story short - I have design jobs coming into rows that have a Sales Respond Date (to a customer) with customizable turnaround days for edits that then gives the designer a due date to complete the edits of a design (Next Update to Client). We use conditional formatting in the designer name column to show a…
-
If Contains Specific Year Formula
Hi, I'm trying to use a formula that will look at a date column to populate another column. If year in that date column is 2022 I want the new column to say Not applicable, but my formula is not working. =IF(CONTAINS(YEAR(2022), [First Receive]@row), "Not Applicable", "") but it's giving me an invalid data type error