Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Discussion List
Duration Calculation not accurate on my sheet
Duration column on my project includes Hours and Days depending on the task. However, the duration count is inaccurate.
Smartsheet needs to have differentiation between a "text" column type and a number
When integrating data in other apps and programs, the data type is critical. Additionally, We need to be able to lock out the data type in the entry. I should not be allowed to type text into a date field or text into a number field. etc. This will enhance the reporting and BI usefulness of this tool.
Formulas using dates
Good Morning! I am looking for a formula that will determine a specific date. I have a column "A" with a specified date and I need to set an alert or notification to be sent 45 days before that date. Is this possible? Thank you!
Project Resource View -- Question about %s
I just started using Resource Management and I'm confused about what the percentages are showing. I may be missing something obvious here! In the screenshot, I have one resource who's assigned to one sheet. But the blue percentage is different from the sheet percentage below it. Why? What do the numbers indicate? I thought…
Cheery picking data from a sales sheet for customer to view
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
How to lock/unlock sheet in oder employees could modify it withing the given time frame?
Hello, I would appreciate your help to my question! :) Every month different teams need to input the information in a sheet within a given time frame, after deadline all information is extracted to pdf and shared with the rest of the company. Many often employees are changing information after deadline, which means that…
Embedded form not redirecting after successful submission
Hi I have copy and pasted the embedded form code into our wordpress website and can successfully receive the entries from the form through the website to our smartsheets account. The problem is it hangs for the person/visitor entering the information in the web form and stays showing a message "Your submission is being…
HOW DO I CREATE ROW HEADERS that cross multiple cells?
Can I eliminate the "lines" between cells to give the appearance of a header? Can I create a header that automatically crosses several columns since there is no "MERGE" option??
Update Form Not Working
I have confirmations from two weeks ago that I updated the Smartsheets through an update email that was sent; however, my updates don’t appear. My staff said that the form that pops up on the email that is sent doesn’t work so they have to update changes directly on the sheet. Is anyone else experiencing this?
Cannot change the start date of a whole project
Hi, I have a project with some linked predecessors in it, but some events without. I am trying to make the whole project start later and keep all the relative dates and dependencies. I cannot select all events and drag - I see lots of arrows that seem to loop back to the beginning. I tried creating a new date column with…