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 January 2017
Discussion List
Outlook on Premise
I know there are multiple comments about Outlook, but I want to make sure our need is known. We are due to renew our annual Team Subscription and the only complaint from management is that we can't integrate Smartsheet with Outlook. This is causing requirements to look for other options when our team does not want to…
Webform link is asking for log in
Hello, Is there anyway to bypass the log in on a webform? I've used the link to embed on our website but anytime anyone clicks on it, it takes them to a log in page. This is not only confusing but it is also detering people from filling out the webform. Any suggestions?
Smartsheet + Jira workflow - attachments and multi-select
We are using a smartsheet to populate a jira project. basically, a user fills out the webform, it updates the sheet, and then we push that into jira. The first issue I'm having is attachments. Is there a way to attach the attachment to the new jira story created from the line item in the smartsheet? it doesn't appear as an…
How to set-up net-30 days in Smartsheet
Although seems very elementary to set this up, however, I am having the toughest time trying to build this "net-30" into our invoicing report. Can someone help me out? Thanks in advance!
IF/AND or ISBLANK formula?
I am trying to evaluate three columns for the ABSCENCE of data to return a value of "Delinquent". For example: I would like the top row of this image to reflect the word "Delinquent" when none of the boxes are checked. Should I use an ISBLANK formula or an IF/AND formula? And what would it look like? Any help on this is…
Insert Time Stamp
Is there a way to insert a timestamp into smartsheet when a specific field has updated? I would create a column that it can be stored in I just don't want to have to have the team manually update it. I need to be able to see what was completed yesterday. thanks
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
Summarizing project KPI´s in symbols
Hi, does anyone experienced how to summarize project data (like deliverables, issues, status and so on) in symbols (RYG balls, arrows)? Do I need a formular for this? I´d like to summarize it to show them at our dashboard. I use symbols already but do not know how to summarize them automatically at the end of the column.…
Combine COUNTIF and SUM
Hello, I have some topics a list were I need to combine COUNTIF and SUM function, but I get stuck. I want the Total calculation (SUM-Function) at the bottom but i want the column only to be added if it fit's with the worker in Worker row. Here I have a screenshot and calulated the total amount for Worker A and B manually…
Scheduled Dates
I am a Project Manager working on a project plan for a technology company. I estimate dates based on the initial project kick-off date. I allow a certain amount of days for each process step. Example: - Kick-Off Date = 01/01/2017 - Estimated Development Start Date =[Kick-Off Date] + 7 = 01/08/2017 - Estimated Development…