-
Date Problem
I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept getting error messages or other strange results. It would be nice if Smartsheet could…
-
Puzzled
I put a discussion out there, acknowledged by the increased badges that I received, but I find my inquiry missing for the past 24 hours. I have not received a message telling me that the information that I posted is inappropriate, so I'm confused. Thanks for what I may be missing.
-
% Concluído x % Planejado
Olá, como fazer para criar 2 colunas com calculo de % de conclusão? Eu precisava controlar nos cronogramas de projetos o "%" concluído x o "%" do que havia sido planejado, como tem no project. Alguém consegue me ajudar?
-
Help on formula
Hi I am fairly new to Smartsheet (3 whole days) 2 questions. I have a dropdown box titled 'Finding Rating' with 3 values: Conformance, Minor Conformance and Major Conformance. 1.Needed a count of each type (so i can create a graphs, on dashboard), I created another 3 columns titled Conformance, Minor Conformance and Major…
-
Trigger notifications based on dates previously input
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc. The other (second) spreadsheet will be a record of materials booked in. Will it be possible that, by…
-
Automatically uncheck column based on date TODAY()
How can I get columns unchecked automatically when they meet a date criterion? For example, all tasks checked today will be automatically unchecked tomorrow because the calendar date has changed.
-
Auto/number - date on particular cell, not whole row
I'm trying to find a way how to populate a datestamp in a cell based on the last change from an another cell in a particular column fe: Row 1 - column A: dropdown (Start, pending, stop) Row 1 - Column B: I want the date when Status changed on column A Auto/number - date: works, but it looks at every cell on that row, i…
-
Conditional Formatting if Calculated
Greetings, yes, here's another post about conditional formatting. I swear that I have searched and cannot find the answer to this, so... I have some date fields that I've calculated based on another (30 days after X date). I'd like to automatically format these calculated cells so I can instantly see which ones are…
-
Is the Parent Row expanded?
Is there a way to know if a parent row is expanded (that is the + sign was clicked and the children are visible)? For example, my sheet contains 3 rows that are parents (Orders 1, 2, and 3 below) each representing a different order. The children of each parent is an item in that order. For sake of discussion and…
-
If column A status is X then tally column B
How do I do this? If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status. Thanks