-
How can I share a report to an user without sharing him paper, source of report?
I would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our project managers. Thank's you
-
Center of Excellence
If someone wants to subscribe to the Center of Excellence, can he/she do that without being a paid Smartsheet user, or does the person need to upgrade?
-
Would like to create a filter that hides completed tasks BUT only when parent row is checked
Hi there, Ultimately I would prefer that tasks that are completed are archived, however in lieu of functionality, I am looking to create a filter view where tasks marked as "done" are hidden. The problem is right now the filter hides ALL tasks marked done and I would prefer it hide ONLY the parent and its subtasks. Please…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Kanban View - printing or saving to PDF
In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
-
#UNPARSEABLE using COUNTIF and cross-sheet Reference
This feels like a dumb question. I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue. The formula is as follows: =COUNTIF({Team SCRUM:…
-
Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column. I have tried this formula: =DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row)…
-
nesting properly?
Hi all and good afternoon, im working on a sheet that seems to be giving me an issue and I am aware its my lack of knowledge. Hopefully someone from the forums can give me some insight as to how to achieve my desired result. I have a cells contents with: =-SUMIFS({Transactions Range 1}, {Transactions Range 4}, ="Issue",…
-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
Assign Workflow issue
I think I've been looking at this for too long and I need help! I received this message "We had additional conditions set up that didn't show disabled, but wouldn't assign on this workflow so we changed them to be OR and apparently it still isn't assigning but isn't showing as broken either" In the attached picture, is…
