-
Month not displaying correctly
I have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11:39 AM and the month column returns a 3. The formula I am using works for every…
-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
-
Best way to manage an iterative process in Smartsheet
We are planning to implement a book publishing project in Smartsheet. At one point in this project, the pages of the book go back and forth between the writer, editor and compositor till it gets finally approved with no further changes being required. The number of times this cycle repeats itself is unknown, however there…
-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you
-
Images (attachements) preview
Hello, we have been using Smartsheet for 4 years now for our project management and documentation. We are very satisfied with all the elements but have one issue. We have a lot of photo material for documentation and the option to upload them to ona row is perfect, but the preview option is very slow and tiresome. On the…
-
using OR in a formula
Hello Smartsheet Community, I'm looking for some help in utilizing the OR statement within a function which references columns in another sheet. I am trying to count how many rows have a request status of either "Open", "Awaiting Addl Info", or "In Progress" from specific departments who submit these requests. I seem to be…
-
Any updates to "View permissions on individual columns & rows"
Hello, The original "View permissions on individual columns & rows" was posted in 2016. The end result appears to have been you could not set permissions for individual columns & rows on a sheet but the request was being noted as a possible enhancement. Has there been any movement on this? I currently have a "Main Sheet"…
-
Added IP Management Functionality
Any Chance of adding this type of Functionality to Smartsheets: https://www.codeproject.com/Articles/712335/Followup-DNS-Lookup-and-Ping-in-Excel
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
