-
Update status to complete
Currently the “Days in House” column uses the Today function to show how many days it’s been since the application was received. I would like it so that when the status is changed to complete, the days in house shows complete as opposed to the date. What formula do I have to use?
-
Recurring dates on a calendar
I am converting some calendars from Sharepoint into Smartsheet, and can't figure out if or how I can make events recurring. For example, I'm building an on-call schedule and the schedules are regular. Every so many weeks, each person takes a turn. Has anyone been able to accomplish this? I don't want to have to enter each…
-
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
-
Sights- how to pull data from different workspaces
Is it possible get sheets in from separate workspaces to roll up to one dashboard (sights) without having to create a report?
-
Importing multiple rows into a webform
I need to get stock declarations from a supplier for about 12 items into a sheet. I would like to send him a webform each week that he can complete and submit back and that will in turn populate 12 new rows in a smartsheet. I would then use the update to update a master stock list sheet (using Azuqua). But I need to have…
-
Send an email to a contact from the sheet?
I'm building a sheet that contains various users in different roles on different teams. I'd like to email the users listed in a column when a change is made to a record. ex. I capture a program manager name in column D and when a change is made to any columns in the row, I want to email the admin (easy, set up an alert for…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Capacity Planning
I have effectively put several project plans in place at work. We have summary reports by assignee working really well for updating multiple projects from one report. The next step is calculating how much work we can take in with the resources we have and planning how much extra resources may be needed in the future with…
-
Magento
Has anyone got any positive experience with linking Magento to Smartsheet? eg just to populate a sheet with orders recived etc.
-
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…
