-
Remove the "0" in the column formula cell.
Help please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the last column meets the criteria, it shows a "0" for the first column. See formula in Screenshot and the cells…
-
Dashboard Chart Widget Axis changes with each refresh
The axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. I have a Support ticket in, but no good response. This is happening on multiple…
-
Formula to add "No" to a blank cell, but leave value if not blank
On a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking for a formula to replace those blank cells with "Does Not Apply" but leave a value there…
-
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…
-
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:…
