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
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
How to Construct a Formula: If Cell is Blank Return Value from Another Cell on Same Row
How is the formula written to do the following? If the cell called "Description" on row 1 is blank, use the contents of the cell called "Keywords" on row 1.
Reverse Engineering a Timeline
Is there an easy way to reverse a timeline that was originally based off of a start date, but should be based on the end date? We plan a lot of meetings where the meeting dates are always moving and we want to adjust the way we have our timelines so we can change the meeting date and Smartsheet can fill in the dates of the…
500 rows per page in reports - Calendar View
Looking back, it appears the maximum number of rows per page was increased from 100 to 500 in order to have fewer customers using Calendar view encounter paging. Seen here: https://community.smartsheet.com/discussion/reports-now-have-500-rows-instead-previous-100 Well, as our company leans more on Smartsheet, I suppose we…
Magento
Has anyone got any positive experience with linking Magento to Smartsheet? eg just to populate a sheet with orders recived etc.
Access resource view through the API
Hi team, Does anyone know if there is a way to access the Resource Views using the API? It would be huge if we could export that data programmatically (as we can do from the UI). Thanks
Fields in Calendar view or dates in card view
I need to be able to print a weekly calendar of the tasks I am assigned to (task name is primary field) and the number of hours each task will take. I have tried doing that in the calendar view but will only show one column field. I also tried doing it in the card view but that won't let me use the date as a Lane. This is…
Sumifs
Does anyone know how many criterion you can have with a SUMIFS? This formula works =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre Description]$21:[Cost Centre Description]$385, [Cost Centre Description]6, [Fiscal Year]$21:[Fiscal Year]$385, [Fiscal Year]6) But when I add one more criterion such…
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
Can you add an item in calendar view?
Can you add items in calendar view, or only edit?
