-
How to bid Materials - Construction question needing solution:
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best solution to take a materials count for my given tasks and then fill in the info I'll…
-
Add RTF (rich text formatting) to Comments
When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF functionality would be limited to manually entered items, not pasted items. The…
-
Avoid access to smartsheet when request for update
First of all, english is not my native langage, please excuse my mistakes. Hello all, I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able to reach / open it. I send requests for update with automatic processes. but when counterpart…
-
Week Number stopped working
Hi All, I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated. The formula is a helper column that is meant to count the…
-
"Item is not currently available" error upon login
We have a number of staff who are accessing Smartsheet, some as registered users under the Team plan, and many others who have free accounts and edit sheets shared with them. On one user's computer, however, whether she logs in with her free account or I log in with my Admin account, the first thing that happens is a…
-
Using Project Management Templates
I'm using the PM templates and the templates utilize a section in the project plan that is called Project Information. It's handy b/c you can use this non-task related information in dashboards. What my issue is w/in the Finance section under Project Info - there is budgets and actuals. I am trying to utilize the children…
-
Date Last Updated?
Is there a formula I can use that would show the last date that a specific column was updated? For instance, when someone checks the checkbox column, could I have a formula in another column that would reflect the date the checkbox was checked? It wouldn't work to have a formula that showed when the entire row was last…
-
Sending Multiple lines for Approval at one time
Hi, has anyone figured out a way to send an approval request for more than one row at a time? I have rows that all need approved that need to be sent in the approval request along with their information, much like a daily notification of changes, however in approval request form. Currently we are able to send for approval…
-
Can you create a master project plan with rollup plans below?
I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task is delayed it will impact the other projects. Is this possible? I don't want to run a report because I won't be able to add…
-
CountIFS & Counting Dates
Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I need to return the value for the total number of existing devices installed. Any help…