-
Combining Two Sheets into a Report
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a…
-
Constantly being kicked out of Smartsheet account and (saved work lost)!
Over the past few weeks, I am frequently being kicked out of Smartsheet while in the middle of doing work. Saved (either auto save or manually saved) work are lost when I get back in. What is the fix for this? I asked other users that share our business account but no one has reported this to me yet. The last time I was…
-
Calculated % Complete
We use three fields to indicate effort: Planned Effort Actual Effort Remaining Effort I created a column called '% Comp" with the following formula: =IF(ISBLANK([Remaining Effort (Hours)]@row), 0, IF([Remaining Effort (Hours)]@row = 0, 1, (([Planned Effort (Hours)]@row) - [Remaining Effort (Hours)]@row) / [Planned Effort…
-
Free collaborators cannot see content
I wonder if anyone else experience this issue and if Smartsheet changed access terms for Free collaborators. I recently created simple smartsheet and shared with 2 people, but they only see empty sheet. no content. any ideas ? how do i log issue with Smartsheet support ? Thanks
-
VLOOKUP Based on Name and Date
Hello, I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range. The data table is weekly updated with new values, and has multiple fields, including name, date and comments. I need to pull a comments field, based on name and date. Thank you in…
-
Why does Smartsheet not bring all columns of excel file when the document is imported?
Why does Smartsheet not bring all columns of excel file when the document is imported? I noticed that the the first 7 columns came over fine but the next 7 did not appear at all. Some of the omitted columns have drop down menus and formulas. Any thoughts out there? It is not a data size issue as there are only 14 columns…
-
Publish calendar excluding summary tasks
I would like to publish my calendar as read only "for anyone with a link" without showing the summary tasks. I have this set up correctly on the calendar settings, but when I publish all of the summary tasks display. Is this possible? Thanks! Ilene
-
How does SimPRO compare to Smartsheet?
Has anybody had any experience with SimPRO? I have a client that is currently using SimPRO who I want to convert to Smartsheet. They are fairly happy with SimPRO as it appears to be a total Business Management solution including Project Management. 1) Are they entirely different programs, similar or do they integrate?
-
Report that tracks attachments from multiple sheets
I have a workspace that contains 104 sheets that is tracking the collection of documents that are uploaded to specific rows within the individual sheets. How can I create a report that tells me which rows are not completed on each sheet?
-
Need Workaround Ideas for Automation Condition
Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on people to always set those 2 fields and save before attaching the file to the row. Without the conditions set,…