-
Sum formula Error When References Results from IF Formula
I am getting an #Invalid Operation error when my Sum formula references a cell with results from an IF formula: =SUM([Column 8]1 * [Column 9]1) results as #Invalid Operation error Column 9 formula =IF([Column 2] = "A", "0.5%", IF([Column 2] = "B", "1.5%")) I've tried to fix by using a nested VALUE= but that does not work…
-
Formula Help
This might be simple, but I can't figure out a good formula for dates. What I have is a column with dates, and another column (Year) next to it that is hopefully an If statement. Something like IF the date is in 2015 THEN put a 15. I need this column so I can reference this Year column when calculating total investments…
-
Conditional Notifications
I would like to be able to set up a conditional notification that allows the next "assigned to" person to automatically receive a notification when the task before theirs is completed or checked. There are about 5-7 different people that would need to receive this type of notification. Does anyone know how I can easily set…
-
How to Admin via Mobile App
I'm traveling and my laptop is fried. I have no choice but to use the iPad app version of Smartsheet. I need to remove several users from my sheets. But I cannot find a way to do that via the app. Does anyone know how to do that?
-
User Management Reports Now Links to Zip Files?
Hi all, Did something change? It used to be, when I selected Download Sheet Access Report (or User List, etc) from the User Management > More Actions menu, a .CSV file with the name and date downloaded directly to my computer. In the past few days, that process has changed. Smartsheet is sending an email with a link to a…
-
Update requests not updating
Hi, Please can somebody help me with what seems like an easy process of requesting an update, but is not working. I have done selected the rows and cells that I require updated and sent them to an external stakeholder as per the documentation and videos. The first attempt did not actually update the Smartsheet, I had to…
-
Construction Scheduling and Management
Looking for an experienced professional to set up a construction scheduling and management process with Smart Sheets. We are presently using Microsoft Project for scheduling. We need to increase the depth of our task and management items from 100+ to 600+. Need more interdependency control and clarity. Residential and…
-
Cell history copying prior entries
Hello. Is there a modifier key or some designation when making cell entries so they display with separate date stamps in Cell History? For example, when I add a note to a cell, the Cell History with the date stamp of my entry will include comments from prior dates, as well. I thought the History displayed separate entries…
-
Reports Down?
Is anyone else suffering from reports not running correctly today? It's 08:58 GMT here and we're unable to see changes reflected when we refresh reports. Thanks Simon
-
Help wanted
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with Microsoft Project and need to revamp our solution with Smartsheet to be more detailed, efficient, and useable.
