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.
Discussion List
Requestor update
Hello All, I have a form that I will be using in our IT dept for the technicians to request a vendor from me. The way we have done this in the past is a tech will email me requesting a vendor to have work performed, but this has proven to be inefficient. I would like to use a smartsheet for this so there is a running list…
Embedded Web Forms Not Working On Mobile Devices
I'm testing out using Smartsheet web forms on our website for form capture. However, it's almost impossible to fill out the form from my iPhone. Does anyone know a fix for this?
Smart sheet inventory template
I love the look of this - inventory management in smartsheet Can someone direct me to the training material to help me see how best it can be applied. Very many thanks.
How to enter a foot mark?
I have a field I enter either the inch mark into ( " ) - that works, but when I enter a single mark, for foot, as in 3 ' x 3 ' - a measurement, where the foot mark is the ONLY thing in the column it just goes to blank instead of retaining that one character.
Tracking actual dates without losing predecessors ?
i use baseline start/finish columns and scheduled start/finish columns. The start column uses predecessors but I also update the start/finish columns for actual start/finish. The downside to updating them is that i lose my predecessors (they are deleted when I manually change start/finish). Is there a SmartSheet best…
Image Field in Card View Tutorial But not in My Sheets?
I am confused on how to get the image field. As i look at the Card View Tutorial it references an image field. This "Image" field is not visible on my current sheets or new project sheets (standard project template). How can i get the image field to show up?
HELP!!! I am working on a nested IF formula that just doesn't work, any help is appreciated.
I am trying to calculate the total revenue per month as well as the Margin % per month from our Sales Pipeline. Some of the projects run into the following month so we need to see what the revenue and margin are for each part of that time frame. I was able to get the formula to work for the margin % but only for one cell…
CountIF check boxes error
Using the formula =COUNTIF(CHILDREN(), 1) in my check box column and it throws the error #1 or 0 expected. There's an article explaining to do it this way (unless I am misunderstanding) https://www.smartsheet.com/blog/support-tip-checkbox-formula What should my formula be instead?
MIN date when checkbox is not checked
Hello, I am looking for a formula that will give me the upcoming date (I am using the MIN function for this) in a range of dates when my checkbox column ("Done") is not checked. The context we are using this in is that we would like to show the next task that is not already completed. This is what I have so far and cannot…
THANKS to all the Formula Gurus!!!
Dear Fellow community, While I know Excel rather well..VLOOKUP, PIVOT TABLES, etc, the LOGIC and IF formulas sometimes cause me trouble. Anybody with me.?? OK.. so I'm doing what my daugther calls a "humble brag" cause I'm tooting my horn, but giving credit to others..... Today (with lots of help and patience), I was able…
