I have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't ma…
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machi…
We are using Smartsheet to build a Change Management process for our IT department. The way it currently works is we have a form that users fill out containing all the details of their change request,…
Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. However, modifying the expre…
Does anyone know if there's a way to limit form access to a specific person or group of people. Or, is there something in the works at Smartsheet to address this? Looks like there is currently two opt…
Greetings, I'm attempting to configure an Epic (parent) field to automatically change based on the statuses of the child fields. For example, the criteria I'm attempting to meet is: If all child statu…
Several staff members from our organisation fell for this phishing email, looks like it's from Smarsheet team (see attached Image) so users click on folder link from an email and their account was com…
Dear All, Our program consists of 5 sub projects and each of them have their plan. All of these individual plans need to be rolled up into a consolidated master plan that would finally track the inter…
Hello, I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message. =SUMIFS({…
IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation…