-
Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
Send Row - Filter Save
I utilize the Send Row feature on a daily basis. The majority of the time, the columns I select from the "Customize" section are the exact same. It would be awesome if I could create a filter and have the ability to select it as opposed to manually selecting all of the columns every time. Thanks
-
Create Gantt from End to Start
Hello! As a project manager, I often find myself needing to make timelines starting with my end date. However, I have only been able to make Gantt charts in Smarsheet (with dependencies) that I can change the very first start date and then the durations, but I can't work backwards or change start dates to meet my needs! Is…
-
Creating groups to sub the lack of creating a workspace within a workspace or a workspace in a folde
Hello all, As other have posted in different forums it would be great to be able to create a Workspace within a Workspace or a Workspace in a folder in order to be able to organize a lot of projects better. What I am thinking about doing now is creating a Workspace for each of the Regions in which a project can be created…
-
One sheet, diffrent collaborators
Dear, We would like to use one sheet/workspace. This sheet with be used by different collaborators with different permissions: 1. On Site; 2. Engineering; 3. Project Management. I would like to make one column with the above mentioned. When i add a task to (for example) onsite. I only want them to see the task for On Site,…
-
Question about tracking project budgets in Smartsheet
Hello all, I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and…
-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
Planview Integration
Hi, Has anyone tried or successfully pulled data from Smartsheet to Planview or any other PPM systems? If so I would be very interested to hear what the requirements were and how it was achieved. Many Thanks Paul
-
DEPENDENCIES FORMULA IN TO A PROJET SHEET
HELLO; I HOPE YOU CAN HELP ME WITH THIS PROBLEM: I NEED TO SCRATCH A FORMULA TO GENERATE DEPENDENCIES AUTOMATICALLY IN A PROJECT SHEET WITH THOUSANDS OF ROWS. EACH ROW CORRESPONDS TO A TASK REPEATED RANDOMLY. AND MY PROJECT HAS MORE THAN 70 DIFFERENT TASKS, SO IT IS VERY LABORIOUS TO ASSIGN DEPENDENCIES USING FILTERS BY…
