-
Smartsheet and HIPAA
Hi Community ... Sharing a bit about HIPAA from the team who helped implement Smartsheet's HIPAA guidelines. Here's the very short synopsis: Smartsheet does not collect or store PHI as part of normal business operations; however, any HIPAA-subject organization with an Enterprise plan that works with PHI can enter into a…
-
reminder to change oil after 5000 miles with multiple vehicles on the same sheet
I have a spreadsheet for truck maintenance on my vehicle fleet of about 15 vehicles, and I am trying to figure out a formula or some way to send a reminder email if the truck has accumulated 5000 miles since it's last oil change. I have columns for the date, the truck I.D., a checkbox for if the oil was changed that day,…
-
Forms in a Template
I have been successfully using a template to create project plans with a form. I've created dozens of sheets from the template with no problem having the form transfer from the template to the new sheet. This morning that stopped working, so when I create a new sheet from that same template the form no longer carries over…
-
Smartsheet Error: formName: ajax fa_loadContainer serverStatus: false serverStatusText: CriticalExce
What is the cause of this error? How can we prevent this from happening again? Is there anyone experiencing the same error? formName: ajax formAction: fa_loadContainer serverStatus: false serverStatusText: CriticalException errorCode: 6
-
Looking to Hire Smartsheet Help
Hi all, I see so many great features with Smartsheet, but have been struggling with having the time to learn the program in order to properly use it. Wondering if anyone with excellent knowledge of the program can offer their services to help me set up some project management and product management templates that I can use…
-
Problem saving a large sheet when insert/remove/move rows.
I have a large Smartsheet with 1472 rows, 30 columns and about 27,200 cells with formulas, mainly IF() functions plus three simple conditional formatting rules. The page will load in a few seconds and simple changes save in a few seconds but if I insert or delete a row near the top of the sheet, or move some rows from near…
-
##Help ME please "i can t continue to work" SumIF##
I post a problem 2 days ago some response but still doesn t work, new to smartsheet but my work is blocke now problem Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name…
-
Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
-
Count Cells by Color
how do I count cells of a specif color in a row? Countif does not seem to do this as it does in Excel.
-
Sumif / Countif
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…
