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
Will adding Data unto Webforms be added automatically to the spreadsheet?
How do I get the data I entered on a webform to get added unto the spreadsheet I am working from? Can I do both or does it have to be either 1. use the Webform or 2. enter data unto the spreadsheet?
How do I use an OR function with a simple IF function?
I’m currently using this simple IF function (If Team Column equals “Undergraduate Robing”, check the box (formula below) but I need the box checked if the team column equals “Undergraduate Robing" or “Faculty Robing” or “Marshals”. Is this possible? Current Formula: =IF(Team1 = "Undergraduate Robing", 1, 0) Any assistance…
How do you change (or can you change) the owner of a sheet?
I am managing the implementation of Smarsheet for our organization. I recently created a sheet to 'test' various capabilities and to determine if it might work for sharing specific information needed throughout our organization. It does; however, now another person (rather than myself) will be managing the information of…
Moving Uploads from a Sheet to Google Drive
We would really need a feature that allows us to move uploaded files from Smartsheet to Google Drive and have a link to this file in Smartsheet instead. If Smartsheet is not offering such a functionality might it be possible to find a thirdparty app that offers this? Any idea would be appreciated.
Formula Help-Finding the minimum value greater than zero
Hello Smartsheet Community, The formula I used in Microsoft Excel needed to be entered as an array. What is the best way/formula to find the minimum value in a range that is not zero?
Resource allocation by project, not by person
Hi, i like the resource allocation views but in addition to knowing what people are working on, I'd like to see what we are using our resources on by project. so rather than seeing that Sue is allocated 50% to project A and 50% to project B, I'd like to see a list of all of our projects and how many of our resources we are…
Formula
I'm trying to build a formula. Date range based off Finish date. Currently I have a date in the Finish date cell and it will populate a text based off the finish date but I really want to do a date range now based off the finish date. Example below the date range would be 02.01.16 thru 09.30.16. Can someone help me?…
Font name/size not retained
I changed the font name and size on my entire sheet to make it more readable, making it Tahoma 8pt. Today I updated a percentage complete field and found it entered in Arial 10 point. Looks like a bug to me. Anyone else getting this?
Why doesnt my assign to list match my smartsheet contacts that I spent a lot of time setting up?
Why doesn't my "assign to" list match my "my smartsheet contacts" that I spent a lot of time setting up?
api 2.0 update of a cell and "Invalid row location."
I am attempting to do a cell update (in python) and it keeps telling me "Invalid row location" and I am not sure how to track this down (or even why the row location is invalid). The call is: sheetURL: https://api.smartsheet.com/2.0/sheets/<sheet_id>/rows data: [{'cells': [{'columnId': '<column_id>', 'value': 'updated'}],…
