-
Row sum based on column value?
Here is a bit of an odd ball. This is a budget sheet that has been simplified for this question. At the end of each quarter the planed amount is replaced with the actual value for the quarter. I need to sum up the total actual and the total planned across all quarters for use in other calculations. Is there as way to sum…
-
Live/Real time Excel docs?
Once you insert Excel doc, how do I make it a live doc so all contributors can make real time changes and have it saved that way?
-
Multiple Sheets - SUM Dollar Totals in Report
I did a quick search in the community and didn't see this answered exactly, but i think either an Excel export or a future release of Dashboards may provide a quicker/better solution. So here's what I'm trying to solve. I've got 10 sheets that track Paid Claims. When the Claim is paid, a field titled "Date Payment Received…
-
tracking incoming jobs & jobs in process
We are looking or a solution for logging in tax & bookkeeping work. What I'd like to do is have a sheet for ALL tax clients. All we'd need to do is log in the client name & type of return. Then The "Steps" would appear. Do you have any suggestions on the best way to do something like this?
-
Coordinating multiple projects and sharing sensitive documents selectively
I have 5 vendors working on a project. All five vendors have tasks which are significant projects in their onw right. There are interdenpendencies. I want to coordinate the project in a way that there is one gantt chart for the overall project which all vendors and their teams can see, their project managers can edit and…
-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
Future Developments
I am a new user to Smartsheet. Still testing it out for the 30-Day Trial. I really like Smartsheet, but am a bit concerned about becoming too involved with it because it does lack some functionality I was hoping for. That said, only a few of the upper end (expensive) project management programs seem to do what I want.…
-
Filtering deletes formulas within the cells and parent rows
I've been struggling all day with a complex sheet, discovering multiple times throughout the day that formula's appear to have been deleted. Before Filtering - every cell had a value, either 0.000 or greater; parent rows were totalling correctly. Action: Filter column 'Q1 Total' to show only those cells that had a value…
-
Formula to calculate week number or week commencing date
I have a column of dates in a smartsheet, and wish to insert a formula into another column what will tell me either the weeknumber (e.g. Excel WEEKNUM formula) or the weekcommencing date. Does anybody have any suggestions how to acheive this?
-
Status Symbols
Can you formulate status symbols to change based on % numbers in another cell?
