-
Using SUMIF when column is not blank
Hello, I am trying to sum only the values of the children in one column for which the corresponding cell from another column is not blank. I tried this formula: =SUMIFS(CHILDREN(Amount25)), (CHILDREN([Date Paid]25), NOT BLANK), but it did not work. Is it even possible? Thanks!
-
Looking for similar to collaborate
Short version. 2 years sales manager. 1.5 smartsheet. Company sizee start 500k annually today 3 million. Smartsheet is our only platform. Phoenix. Haven't found anyone that will take me seriously local on smartsheet, have used freelance again lack familiarity. Tried support no follow up back. We have local guy trying to…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Calendar integration for Outlook (2010 et al.)
Hi, We use Smartsheet as an events listing and it would be useful to have integration to Outlook through a calendar. At the moment it displays rows as an all day event it would be beneficial for it to use the time fields we input so that it gives us a true indication of the event timeframe.
-
How to get rid of 'Report Abuse' and 'Privacy Policy' in a published FORM?
It is very annoying to see these two links on a form. How can I take them off?
-
Cut and paste rows from Excel without importing an entire sheet
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
-
Precedents no longer working when copying the sheet
I have a project sheet that has worked perfectly for about 10 months. It has lots of dependencies already set up. I made a copy of the sheet and removed all of the dates (highlighted them all and deleted). I have changed the names of some of the rows but the duration of every task and it's depedecies are still there (which…
-
Webforms for help requests - best practices
We have a webform created that our customers can fill out to submit help requests. What is the best way to disseminate this webform and make it available for them to fill out? I don't want to have to email it to them, but at the moment I don't have a space on a webpage to embed the link/form. Would that be the best way to…
-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
request
smartsheet is and how it Uaj month in what seems to Sir please Helf