-
Full year calendar - accounting month/quarter end
Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to see this in a calendar view Any suggestions on how to build this? ie: Formula for the 'due date'…
-
Count Rows from a report, not sheet
It would be great if Smartsheet could provide a count of rows in an already generated reports, and if that count could be cell inked to. This is not the same as criteria based counting in a sheet, which is great unless you are trying to use lots of variable discrete criteria.
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Templates for Architecture Projects
Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific processes.
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
Dynamic View Questions
Good Day All, I am trying to familiarize myself with Dynamic View. My questions is, upon sharing the view with someone (lets say I share with my accountant) how do we send requests to update things WITHIN dynamic view? Let me propose an example I need to get an update from my plumber on his repair of a pipe. I want to know…
-
Can Smartsheet get data from custom HTML forms on a website?
Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. Thanks in advance!
-
SmartSheet (A) > MS Flow > SmartSheet (B)
I have a Master SmartSheet from which I pull new rows into a SmartSheet Report. That works fine for Report users who are safe to have access to all the information in the Master SmartSheet. However, I have other users who need some row data but not all row data (I need to restrict user view of certain data). To do this I…
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
