Does anyone know if the web form functionality will incorporate a slide bar rating scale? This exists in Surveymonkey and my Marketing team still uses Surveymonkey regularly because of this feature vs SmartSheet web forms. thanks!
I am trying to do a year to date calculation on some sales data but would like to bais it on this years sales vs last years sales to keep track of how we are doing month by month. Do I need to do a horizonal lookup? A sumif? Is there a way to add a current date to the sheet, then simply do if sum if >= to this date? Please…
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
I have a form on our website for people to enter info. I have a email from Smartsheet with a request from someone using the form to have me share the sheet with them. How does this happen? Skip
Is it possible to print a Sight view? I spent a long time setting up an attractive Sight pulling from a report and other data and now want to be able to print it. What are my options? By publishing it to a URL, will I be able to print the URL view? Thank you for any feedback!
I want to create a purchase order form that I can send to suppliers by email from SmartSheets and receive a confirmation form back by email that the order is accepted with delivery details. The purchase order will need an internal authorisation. A unique PO number. Entry into the Smart sheet on authorisation. Ideally the…
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
Hi Guys I have two columns of data that I want to summarise with a count into a specific cell where the follpowing conditions are true: The first column is NOT blank AND the second column IS Blank. Not sure if CountIf's is right for this. Any help would be appreciated! All the best Barry
I used this "Auto-system - created by" column property and what appear in the column is the email address of the user who collaborator who created the row. Is there a way to changed it instead to the name of the user who created the cell. Thank you.
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far: =IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)…
