-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Copy Conditional Formatting Rules
Hi, I tend the same conditional formatiing rules across several Workspaces and sheets. Is there a way to copy the rules so I can use them on new sheets? Thanks.
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
-
Conditional Formatting not working
Hello, I've created conditional formatting rules that are not working. They work if I set the rule to "is not equal to" but when I set them to "is equal to" they stop working. The spreadsheet contains "#NO MATCH" cells automatically formatted from another sheet. I want the "#NO MATCH" cells to turn red (not the whole row).…
-
using netdays to detemine number days from quote day to closed
I am using the following formula (gained from a previous community entry, thanks guys) =IFERROR(NETDAYS([Construction quote date]@row, TODAY()), 0) it is calculating the number days between a quote date column and today's date. however I want to fix the number of days when the actual close date is entered into a cell…
-
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…