Possible Easy Percent Question
Hi! I am trying to do a percentage of how many yes and how many nos I have in one column. I tried a couple of formulas and I am coming with some weird answers. For instance. =[Percentage of IPE Yes and No]1 - [Percentage of IPE Yes and No]2 / [Percentage of IPE Yes and No]1 and my answers comes out to be 4,773% I have also…
Trying to connect a check box column to a completion date column
I am looking to connect a column in which I have a check box indicating done (check) and not done (unchecked). On the same sheet I have a column for Completion Date. I would like the sheet to auto-populate the Completion Date field each time a check box is checked as done. Is that possible?
Smartsheet Budget Formulas
Hi, I would like to know the formula for the due date of every month to calculate the receivables and Payables. For example, I have the data with amounts and due date of the payment. How can I input the formula, grab the amounts by the due date of every month. Please let me know.
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
Hello, I am recently unable to save changes made in Smartsheet. I have tried everything that I can think of to get around this glitch, but nothing is working. Has anyone else run into this problem before? See screen shot attached. Thanks!
Assigned To Notifications Not Working
I have several sheets with Assigned To notifications set up and they are not sending emails upon assign. I'm hoping I'm doing something wrong, but I've searched these boards and it looks like I have it set up as suggested. Here is a pic of my settings. Please help!
Opening a link to a sheet (Smartsheet), while utilizing the Smartsheet App
I have employees that exclusively operate within the Smartsheet App (iPhone & iPad). The sheets that we are working with, contain hyperlinks to other sheets. Upon opening the link to another sheet, while in the app, it redirects the employee to the web version of Smartsheet...it does not open the link in the app. I am…
Create a report form from single line entry
Hi, we use Smartsheet to track customer requests and action plan to resolve. I am setting up a webform for quick entry and would like to print a "report" or something that is easy to pass on to the appropriate person. It would need to be for only one line on our smart sheet page. I know I can click on the line and "Send" -…
Sights Widget to Display Update of Any Changes of an Entire Sheet
I Desperately Need Help with understanding how to use a report and/or widget feature to display an automatic update of date whenever anything on a sheet is modified or changed. I would like for this to pop up on the dashboard I am creating as "Last Updated As: 5/5/2017" for an example. Can anyone please help? I have…
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…