-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
Date Problem
I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept getting error messages or other strange results. It would be nice if Smartsheet could…
-
Troubleshooting formula and or row
I created a formula, but have problems. The formula is ........ =IF([Status Date]@row >= Today@row - 14, "Red", "Green") ....... The formula work fine in some rows, but not all. I'm puzzled as to why this is the case. Does the master sheet need to be purged for underlying errors of some kind. I can't duplicate the error…
-
Puzzled
I put a discussion out there, acknowledged by the increased badges that I received, but I find my inquiry missing for the past 24 hours. I have not received a message telling me that the information that I posted is inappropriate, so I'm confused. Thanks for what I may be missing.
-
Roll Up Works REPORT only partially
Hello, I know that reports have been an issue, but I think I have a strange problem. My reports are not refreshing with the latest data, even hours after the Roll Up sheet (on which the reports are based) is updated. When I go to my Roll Up Sheet (on which the report is based), and scroll all the way to the right (as if I…
-
Sorting by Date in Exported Excel File
When I export a sheet (Gantt Chart with timelines) to Excel it doesn't seem to sort (e.g. by date) all the rows when indented Task Names are present. It will only sort the highest level Task Name, but I would like to sort all the rows regardless of the Task Name hierarchy. Is there a solution to do this, or possibly a…
-
Create Hierarchy Relationship using WBS and Formula?
Hi, I believe this may be a bit of a stretch but I am wondering if it is possible to automatically create the Child/Parent relationship utilizing the numbers or periods in a WBS # column as a way to automatically create the indention. I have built a pretty good process using Smartsheets data uploader to import external…
-
Referencing another sheet for selective information
Any help with this would be appreciated. I haven't been able to come up with a formula that would check a reference sheet for a value and pull the data from another column to populate the current form. I expect it would be a compound formula with an IF and maybe a INDEX, but I'm having difficulty narrowing it down. - Any…
-
INVALID OPERATION in one column but not the other
Hello, I have the below formula in three columns in my sheet. They are all referencing the same master sheet, same dates, same facility, same units, but different utilization rates. Two of the three columns are working great. The last one isn't. I re-typed the formula in several times, following the other columns' formula,…
-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…