-
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…
-
Saving Errors
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…
-
Counting A Range of RYG Balls at Once
I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540. I have tried various formulas but I keep receiving and error. Can someone help me by letting me know what I am doing wrong? Here are few formulas I have tried. =COUNTIF(CHILDREN([Status of Completion]1:Status…
-
Gantt view default??
My gantt chard defaults to the earliest date in the sheet. I need it to default to today's date. Help?
