-
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
-
Extracting part of a cell to return in another cell
I'm trying to come up with a formula which will take the website URL in one cell, extract what's called the root domain (website.com) without www. or https:// or any url string after the .com Here's a couple of examples of the value I have in the cell and what I would like it to return in a horizontal cell:…
-
How do I concatenate contact names from different sheets?
How do I add a contact name from a sheet to a cell in another sheet that has already other names? For instance in sheet 1, column 1, I have Person One and in column 2, I have Person Two and Person Three. How do I add the 3 names to another sheet in one cell? Thanks!