I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
Hi I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval. I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines…
All I seem to get is a link to a form - not a form embedded into my site?
I would like to calculate the cost and hours of multiple projects in one sheet, I would like to see how the cost and the hours of the project are increasing and decreasing in the various phases of the projects. I would also like to put this information on my dashboard and report it to leadership as a visual report.
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
We have locations in 8 states and are looking for a way to centralize purchase orders and accounts payable. Has anyone used web forms to create and track purchase orders in Smartsheet?
I created a new column "Effort". I want the "Effort" rolled up to the parent. That is not happening. One of the FAQ states that column must be a dependency column. However, I can only see "Predecessors" and "Duration", when I go to <Project Settings/Dependencies Settings> One way is to add a formula in the parent cell is,…
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
