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. Archived 2017 Posts
Archives for November 2017
Discussion List
Smartsheet to create invoice from Quickbooks
Hi, I would like to know if we integrate data in smart sheet for invoice, will it create invoice from QuickBooks or when we create an invoice in QuickBooks, Can we get the data in smartsheet?
Sum every other row
How do I add up values of all odd or all even rows? I've tried =SUMWIN(WIN1:WIN119,MOD(ROW(WIN1:WIN119)+1,2)) but it didn't work (WIN is the title of the column)
Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula
I need to add another scenario to one of y formulas, If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose…
Calendar dispay
I have a task sheet with assigned dates. They are assigned to people. What I want to do is create a calendar showing who is assigned a task each day. However the calendar view is showing the ID number instead. How can I change this?
Trying to add a Sheet Data widget to a sight
Hi, I'm trying to create a Project management Dashboard but for some reason, when I click on "add a widget", I don't see the option to add a Sheet Data. Does anyone know why and how I can do this? THanks! Carine
Formula Help!
Hi Everyone, I am needing help with a formula. I need it to function as =if "Wet Paint" has check mark, change "Lane Designation" to Wet Paint. Thanks for the help in advance.
Date linking or date formulas
Hello, I am not sure the best way to summarize what I am asking in to a search string so thought I would just ask the community. So right now I have a very dynamic production schedule, since we are a new company and still learning / growing we constantly update our production schedule (sometimes daily). My question is, if…
Checkbox Parent Cell if any Children cells are Checked
Hello, I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked. Can anyone help with that? Thanks
Report - Imported sheets are shown but new Project Sheet does not
Hello, The majority of the time we import an MS Project schedule and have had no problems with pulling those into a report. However, if we create a new blank Project Sheet and enter the tasks through the web interface, those sheets do no get pulled into the report. The columns for the Start & End dates are different…
Assinged too.....how do i
How do I remove extra names in the drop list? In the early days I entered the wrong e-mail address, now I have two Heath with different e-mail addresses, I cant remove one of them.... Can someone help please ?