-
Can Smartsheets talk to each other?
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…
-
Referring to a Cell in Another Sheet that Contains an Hyperlink
I am wanting to refer to a cell (or find a match in a range of cells) in Sheet 1. The cell in Sheet 1 contains a hyperlink. What I get in Sheet 2, however, is just the text in the cell, not the text as a hyperlink. Sheet 1 (contents of cell, text as hyperlink): BUS 123 6Wk Online What I get in Sheet 2:(text but no…
-
Mirroring the most recent date to another cell
Greetings I am attempting to complete a project where routine maintenance tasks are assigned in rotation between 3 shifts. Tasks are cycled Bi-Weekly, Monthly, Bi-Monthly and Bi-Yearly. I have a formula that is suppose grab the last date in a date column. The date that is being referenced in "BY1 Date" is applied by a…
-
Formula to Calculate Total Score
Hello, I am trying to resolve a formula to calculate a total score in a form for weighted values based on selected criteria. It works in excel when I create a table but not working in smartsheet form and getting #unparseable error. I have 5 criteria each with 5 option to select from. Each option returns a weighted value to…
-
Formula Error
I am trying to highlight and mark duplicate records with the newest Created Date, but I am getting this error... #Incorrect Argument for this formula... =IF(COUNTIFS([Order/Work Order ID]:[Order/Work Order ID], [Order/Work Order ID]:[Order/Work Order ID], [Order/Work Order ID]@row, [Created Date]:[Created Date], @cell <…
-
Multiplying different criteria and summing
Good Afternoon, Another challenge I can't quite to conquer: Here is the formula that works: =COUNTIFS({Emp Status}, [Emp Status]@row, {Rank}, ="OFC") * 4 I want to add other Ranks and combine all the totals: CPL/DET *4, LT *10, CMDR *12, AC *12, COS *12, Chief *12 If anyone has suggestions.
-
Subject: Adding weighting/points to answers within a multi select dropdown?
-
Sheets with cumulative values
Sheets with cumulative values We want a low-maintenance sheet that Uses column formulas Accepts new rows via forms Contains a running total in each row (e.g. budget minus spend) This would allow each row to show the diminishing budget — a burndown report. We found this answer by Leibel S. that is letting us create column…
-
Formula to identify the season of the year
Good afternoon; I would like to know if it is possible to create a formula to obtain the name of the season of the year related to a date; the idea is to be able to filter the seasons and set an anticipated schedule for the activities depending on the weather.
-
Trying to add informtion from two sheets
I have two sheets with the same column and I am trying to write a formula that says to only count the cells that say "Red" in them. I got it to work with a single sheet but I need the total to be from two sheets, the current and the archived. This is how I wrote it but its not working =COUNTIF([REPORTING Screeners…