-
Working with dependencies is a nightmare
Dear Smartsheet, I have a two change requests, because at the moment working with dependencies is really inefficient and time consuming: 1. Auto calculate lag when creating dependencies: when I create a dependency it automatically changes start or end dates. This is very annoying and time consuming because you always have…
-
Smartsheet Automated Tasks
Can you create an update request to have Smartsheet read incoming data being added to a new row for duplicate information? We are considering creating a web form for people to "register" with us and want to prompt them (or our staff) if they try and register twice.
-
Will renaming a sheet change it's secure sheet link?
So I have a sheet shared with a community of engineers. I will call it Sheet A. It is also viewed by others. Recently we have brought in another team of engineers to assist with a project and I created a duplicate sheet which I will call Sheet B. Sheet B was to be identical in nature to Sheet A The new Sheet B has dates…
-
Charts From Drop down Data
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
-
Pulling Tasks into a Report Using Multiple IF(AND( formulas in the same cell
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Is there a way to know current sort criteria?
I got invited to edit a sheet, which I'm pretty sure is sorted. The sheet has way too many columns for me to quickly check the criteria. Is there a way to know what criteria the sheet is sorted on?
-
Formula Help Needed
I need a status formula for the parent row of up to 5 children rows. The children rows have a control rating of 1-3 If rows 1-5 have a control rating of 1, the status column should reflect "Closed" in the parent row. If rows 1-5 is 2 or 3 then parent row should show "Work In Progress" If ALL are blank then status should be…
-
Revision Control - Best Practice
With an AS9100 Audit coming up for us, many have asked if our Smartsheet templates need to be revision controlled. Does anyone have any insight on this they could share?