-
Return task name associated with a future date
I have a project with linked tasks. I can get the start date of the next task using the following formula: =MIN(COLLECT(Start2:Start6, Start2:Start6, >TODAY())) How can I return the task name associated with this upcoming task? In this example, this formula gives the next start date as 6/19/19. What formula will return…
-
Formula for Actual duration excluding duplication
Hi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous time ranges. Please see example: Start: 01/10/2019 End: 04/10/2019 = 4 working days…
-
Created Date Formula for Forms
Is there a formula that will capture the created date for new entries on a form? Once the form is completed, I would like a column to automatically populate the day that row was added from the form so I can track response times. Is there anything like that available other than the audit log?
-
formula not working on row1
Hi , Can anyone help why the formulas are not working on row1.I mean i am not able to use any formula on row1 Thanks
-
Weekly progress report - project related
Hi , Need a help of team. complex one :- I have Project Plan sheet for following data below screenshot 1 I want to create a report based on status and weekly progress % Complete as shown in Screen 2 to create a dashboard chart as shown in 3 to show it in dashboard.. Can you help me on it. Also, this weekly progress report…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
Formula for 2 columns - checkbox and a date range
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the…
-
Logic Project Plan
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50% Can any one help on…
-
Generate Kanban based on fields in linked Smartsheet
Hi there, Is it possible to link a Kanban to a Smartsheet, so that cards are generated based on various fields? I don't want to change to the Kanban view as already offered, but generate cards dynamically as rows are added to a linked pre-existing sheet and specific fields are checked. E.g. if "Email campaign" is checked…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…