-
help with formula
Hello, I'm still quite new with sheets and I wonder someone can help me out with this formula I'm currently struggling with. What I want to do is to check/compare email addresses. The following works well when adding formula to a check-box type cell comparing whether the [Modified by] entry is the same like [Email] entry.…
-
Dynamic Publishing - is it possible?
Hello, We have been using Smartsheet for a while but mainly to assist with our project management tasks and I am pretty much a very basic user in terms of skill level. However, we have a new requirement and exploring to see if this is something that we can use Smartsheet as well. We are looking to move our gifts registry…
-
Unable To Change Workflow Option To Run Hourly.
Hello, Is there a reason why my workflow will not save when I select to run it "Hourly"? The only option that works is "When Triggered". There is nothing that is telling my I need to add information (no red boxes). I click save and nothing happens.
-
Managing Multiple Audit Sheets
I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants,…
-
Autosave for editors
Hi all, I'm relatively new to Smartsheet and I'm just starting to introduce it to some groups within our company. I have a question regarding the autosave function in the personal settings. I'm an admin to a few sheets that I share with all different users. If I have the "Autosave my changes when I leave a sheet, report,…
-
Tracking changes to a Column within last week
Hello, I'm trying to find a way to count the number of items which have been updated to a 'complete' status within the last week. I have 10 sheets and they all have a status column (not started, started, complete etc.). I've tried using the 'modified date' column to determine if the status was updated, although I'm aware…
-
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
-
Project scheduling - moving from Excel
We currently use Excel but want to move our Scheduling spreadsheet to Smartsheet. Here are some details: * We have 8 employees that can weld. * Some of the 8 can work on small parts, some can work on large parts, and some can work both. * Our Sales Orders may contain small parts, large parts or both. We list how much time…
-
Predecessor formula
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be…
-
Feature Request: Static formula's for a column
My Sheets are heavly Forumula laiden and this, in itself creates an issue insofar as each time I create new rows I have to ensure all my formulas are copied from a blank row. I'd love to be able to define a formula inside a column that means that the formula is ALWAYS used whenever a new row is inserted etc.