I have a sheet that has multiple activities recorded on it. The attached picture has an Activity Name column and Activity Date column. We had a Wellness Session on July 19 and a Perioperative session on July 26th. We will continue having events all year long, so this will not be the only two events on this sheet. Each row…
Ok, I tend to think I am someone decent in Smartsheet, but I am STRUGGLING with something so simple and would love some help... Background - I have a project team and we use smartsheet forms for time tracking. Every month we archive the previous month's data on a separate sheet. However, to calculate metrics, I do a SUMIF…
I have salesman that use pdf fillable forms for company use. I created a sheet that has all the forms in it as attachments. When using the desktop version they click on the attachment and it brings up the file and they file in the information and can print it. They are unable to do this in there smartsheet app for IOS. I…
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
Is there any way to set font size and type to default on every sheet as something other than Arial 10?
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-licensed) individuals who execute the tasks assigned. Am I correct in thinking that each…
Good afternoon. I am currently using Zapier to automate the creation of a project sheet once an initiative gets approved on a log. The current configuration is the following: * New initiatives are captured into a sheet called "Initiatives Log" through the use of a form * Approval of the initiative is captured on a column…