-
Smartsheet Sorting
Hi, Is it possible to sort data without having it sort the first two rows of data because the first two rows of data are my column titles. My column titles are just repeats of the smartsheet column titles. Thanks! Kevin Au
-
Month/Year to text
I am trying to extract the month and year out of a date column and join them to create a unique key. For example the value in the date column is 8/18/2017 I need a formula to return 82017 I can extract the month and the year without a problem, but when I try to combine them I get the sum of 8 and 2017.
-
Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
-
Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
-
Add up prices in a column if checkbox is selected.
I have a list of parts and prices. I would like to have a total cost add up for the rows selected by a checkmark. Basically it is a parts list and I am trying to add up for a quick quote the items selected. Is there a way to do this?
-
Due Date based on Priority and Date Submitted
Hi, Was just after a bit of help with a formula I am trying to produce. We have a sheet with a column 'Priorities' of Low, Moderate, High, Extreme. We then have a column titled 'Date' I am trying to automate our 'Investigation Due Date' by IFS formula. That is priority is Low or Moderate the Investigation Due Date will be…
-
Update status field based on End date and %completion
Hello All, I would like to do some conditional updates in smartsheet based on below: 1) I want status field to reflect Green if End data of task is greater than today's date 2) I want status field to reflect Red if End data of task is less than today's date and % completion is less than 100%. 3) I want status field to…
-
If & AND equals checkbox
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box Thank you in advance
-
Filtering Older Data
I was wondering how to use smartsheets to filter out older data in a log. For example in a purchasing log, what I did at first was creating a checkbox column with cells such that a order that arrived for longer than 2 weeks will be filtered out: =IF(AND([Last Modified]1 < TODAY(-14), Status1 = "Arrived"), 1) That function…
-
SUM IF & LEFT @cell
I keep getting the result of 0 I am trying to sum a range if another column contains "Street Lighting" I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below. =SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to…