-
Merged: Default Sorting
This discussion has been merged.
-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…
-
Formula error when trying to collect the next task due end date.
I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary section. I now want to collect the due date for that task. I have a column for "End Date" but not matter what formula I do, I…
-
How can i sort the workspace folders/reports
Hi, i've been trying to sort in alphabetical order of my reports in the workspace, it's not working so i tried to rename it by using numbers infront of the name still it's not working please help
-
Canada in Form Phone Validation
Greetings, Field Settings - Validation - Phone. If you select Canada and save it. The form will display the United States. I went back into settings to double-check the settings were still set to Canada, while the manage form view displayed the United States. Ultimately, my goal is to automate a dropdown with logic that…
-
Identifying Current working Task and it's Parent
Good day! I've been reviewing quite a number of ways in finding the current task, last completed cell in a column, etc etc and cannot get what I need to work. I've attached screenshot with the data in my sheet and I'll provide the formulas below. What I'm after is looking for the last non-blank cell in the Status column,…
-
Column Filter
Hi all I am not sure if I am missing something with the way filters work in Smartsheet but is it right that I cannot add a filter to each column which automatically updates the list of inputs from the data in the cells below it? Basically I want what Excel does when you highlight the titles of a column and hit the filter…
-
Report connecting multiple sheets
I would like to create a single report pulling data from multiple sheets based on primary column, start end date, Assigned to and status. How could I achieve that? Currently even if I add multiple sheet to report criteria it pulls data only form 1 sheet.
-
How can I use a calculated duration that uses my own formula?
I want to use my own formula to calculate duration. I've added a Calculated Duration column, but I can't select that column in my project settings. What governs what column you can select for your duration column?