I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
I am trying to write a formula that checks for 4 criteria; a. That the result in cell [Transition]38 = "Transition" b. That cell [NPS %]38 is not blank c. That cell [BG KPI]38 is not blank d. That cell [LE CM %]38 is not blank If all 4 criteria are met, then YES, otherwise NO. Of the cells referenced above, only [NPS %]38…
I have a schedule with close to 2000 lines. I am adding columns that need calculations in them. It currently takes me close to 15 min to either drag the formula down or copy and paste chunks. When I create the column why not provide me an option to enter the formula then and apply that to every row? Smartsheets has been…
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
I solved it never mind. Thanks if anyone was looking at this. I have a sheet that is moving very slowly, in fact the entire page doesn't seem to work when I have the sheet open. It is less than 30 columns and 100 rows, however it has many lookups and column references due to the nature of what I am trying to do. below is a…
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
Below is a screenshot of the sheet that I am trying to create a formula on. What we need is a formula that will calculate the Quantity x Unit Price + Extra Charges = Total Price. BUT we only need this calculation if Fixed Quote $ is blank. If Fixed Quote $ IS populated then we need that value to populate in Total Price.…
I'm having difficulty with this one. I have a parent row of "Rental Lead" I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"
Hello, I am new to Smart Sheets and apologise in advance if this is a simple question... Scenario: I have a sheet that is updated via a Web Form and i would like to have a Job Status updated depending on a few conditions: IF the Operator is equal to Unassigned then the Job Status is Unassigned IF the Operator is not equal…
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
