-
Formula to copy contents of a sheet to another
I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets. I am aware that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any…
-
I need a formula that allows the following
If the Created By is Blank then insert the Create By data in the New Created By Column but if Created By is Not Blank then insert the Created By data into the New Created By column.
-
Formula to calculate End Date and Time based on Start Date, Time and Task duration
Hello, I'm looking for a formula to calculate the End Date and Time (MM/DD/YYYY)( HH:MM AM/PM) based on the Start Date and Start Time entered on a form using the Task standard routing time.
-
Managing Different Workings Days
The idea would be to be able to manage working days according to specific groups of employees. Some of our manufacturing technicians work during the day, some during the night and some in the week-end. This option would either let you create a group of workers and assign them a specific work schedule OR when you create…
-
Configuring a Metrics Widget - can it be done?
Full disclosure - I have been using the PMO template and modifying it for our needs. It was a great starter, but needed some additional tweaks to suit our purposes. I added a sheet that dynamically collects all the unique names to make it easier to dynamically display them on my dashboard: (a big thank you to @Cleversheet…
-
I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.
I am using the Hierarchy formula, =COUNT(ANCESTORS()), to label my project tasks. A lot of the child tasks have tasks below that, going to a hierarchy of 5. I want to create metrics sheet that shows the estimated completion date for the lowest level child. Because the levels vary by task, I cannot choose a specific…
-
Have I crashed my system??????
In an effort to remove a cell link, I somehow managed to lock myself out of free text cells. I am able to use cells with drop downs or dates, but I cannot free text in any designated free text cell in any of my workspaces. When I start to type, there is a little blue dot in the upper left corner of the cell that I don't…
-
Is it possible to create a workflow to transfer indented rows to a separate sheet?
Is there any way for the workflow to trigger and move the indented row independently from their parent row to a separate mirrored sheet (exact same set up)? My specific scenario: Tracking form numbers that fall under different categories (series/subseries). The forms are indented to be nested under their respective series…
-
Countdown for days until due but stop counting after due date has passed
Hiya, I am trying to write a formula that will count the number of days until a task is due but will not start showing negative numbers once the due date has gone by. I came up with =NETWORKDAY([Today's Date]@row, [Date Next Check/Validation Due]@row) But couldn't figure out how to make it be blank once the Date Next…
-
Can I display all the values from a column on one sheet to another?
Hello Smartsheets, I'm attempting to have a sheet which can display the values of a particular column on "sheet A" to a column on "sheet b." Sheet A's column has repeat information (job names) that associate with different items. So the job name on Sheet A shows up multiple times with different items in different rows. I…
