-
Adding attachment via the API
Hey, I'm using the API to create a sheet and I want to attach a pdf to each row. It looks like I would need to first create the row, then get its rowId before I can add an attachment to it. is there a way to include the attachment as part part of the row creation? Basically, is the rowId mandatory, or is there a way around…
-
Hierarchy from Excel
Hi all, I have an Excel sheet that I export from TFS and has a hierarchy defined. I would like to copy it into Smartsheet and maintain that hierarchy without having to manually recreate it. Can this be done? I am not opposed to using Excel to reformat appropriately. I am just trying to avoid recreating the hierarchy every…
-
API write over a sheet
Hey, I want to feed my sight/report with a sheet refreshed once a day, however I'm not able to find a way to write over a sheet so that the sheetId remains the same. There are too many possible changes to use updateRows, as some of the rows could be removed and/or added as well as updated. Is there a way to write over…
-
AppSheet Date format
Hi There Although I have set Data locale as English (Australia) the date format on AppSheet is still American Format/ shows 2/18/2016 should be 18/2/2016. Could you advise if this is an issue that can be fixed or a future enhancement? Keep up the great work - AppSheet = Love it.. Regards Wayne
-
Dependencies, critical path and changing dates
Hi everyone, I have some issues with the dependencies function in Smartsheet and was wondering whether someone could help out. I am really keen to see the dependencies and the critical path, which are possible in SmartSheets. However, I found two issues... * 1. I would like to be able to see, that if I want to change a…
-
Creating a Report is slow
Or is it just me? Or my Windows PC? If there is something I can do on my end to speed this up, I'd like to know. I have Chrome open (Firefox is MUCH worse) and can view the Home Tab. Go! I click on Create New > Report and watch the loading screen - 12-15 seconds (Firefox 17-20) the Report is created but is not open 1. Time…
-
Enhancement Request: Better looking printed Gantt Charts (from exported PNG)
The text is too small and low-res. If you could make it more readable - I am printing out a huge chart on 12x18 paper and it's barely legible due to the weird, robotic-looking font that is super small. Some configurable options for the font that gets used for Gantt charts would really be awesome. I should specify that I am…
-
Lock a Sheet/Tab on main view
Not sure if this was a previous discussion item, but wondering if there is a way to lock a specific sheet to always show up in your main SS page when opening.? I made the sheet a "Favorite" but it always seems to get closed
-
Hiding a column using conditional formatting feature
I am in the process of creating a survey for my work place. The survey questions are all yes/no questions. These questions take form of their own individual columns on the spreadsheet. Some of the questions have nested follow-up questions, with responses being children to a primary parent question. For example: " Do you…
-
date calculation
I want to calculate the actual number of workdays from a scheduled start date and scheduled finish date but i keep getting the wrong answer. a project started May 9, 2016 and is scheduled to complete on June 16, 2016. My date calculation says that's 27 work days which is incorrect. the formula i used is…
