-
Formulas for % Allocation in Resource Manager
Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on it and haven't found a straight answer yet, but it seems as though having a formula…
-
Notification Email: Send to Contacts in a Cell
The below form was built that when it is approved you will have 3 email alert notifications (i.e. 1. facility lead contact email, 2. HR contact email and then a set of 3. recipients). Would you be able to show me how I can use the HR contact email in the workflow noted below when a form is approved. When an approval…
-
Gantt chart - date fields ok from formulas?
Hi, all. I have data in table where two date columns are derived from formulas. When I try to use the Gantt chart functionality it says that my grid needs at least two dates columns and doesn't allow me to continue. I have two date columns but they are derived from formulas. Does the Gantt chart functionality not recognize…
-
Missing Automation
I have a workspace with dozens of dashboards, sheets, reports etc. I am testing a notification automation, and it is not doing what I want it to do (there are way too many uemails) at this point I want to disable it. When I went back to the sheet I thought I created it on, the automation is not listed. Is there a way to…
-
Creating a Lookup Sheet
Hello My Fellow Smartsheet Gurus, Today I am in need of some advice. I have a rather larger sheet used to track requests. I have a separate sheet that allows user to type in the a lookup ID and it pulls all the relevant information into a page like view (see attachment) that is easily printable as it scrolls down vs.…
-
Track minutes
Hello, Can I please just confirm the only way to track hours & minutes in a sheet is by paying for either the 10,000 feet or Bridge add on? Thanks, Charlotte
-
Dashboard Help!
Can a graph on a dashboard display only the summaries of a report? I have regional summary sheets on multiple grids that I then have bought together in to a report, and then used the 'summary' tool at the top of the report to show me the national figures. I want to then show the national figures (the ones now in the top…
-
Working around #CIRCULAR REFERENCE error to use the same formula multiple times?
I have this formula: =AVG(COLLECT(IIQ:IIQ, [SE Manager]:[SE Manager], "John Lennon", [Row Number]:[Row Number], @cell >= 27)) I would like to use it in multiple rows. However, I get a #CIRCULAR REFERENCE error when I do, because it is used in the same column it references, so including more than 1 instance of that formula…
-
Sharing Issues
Hi, I've shared a 2 different sheets with a broader team. Both sheets were set up at the same time. The first sheet is shared and has no issues with 100+ users. The second sheet is having issues as shared users are reporting after I've authorized them and they have accessed that they can no longer access after logging out.…
-
Graphing on Smartsheet.
Is there a way i can filter data on a sheet and the graph linked to that sheet reflects those changes? I try to filter out some elements on the sheet but the graph will not change. Thank you