-
One off Saturdays in Gantt
Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?
-
Pictures using Windows Devices on forms
Does anyone know a way to directly take a picture and attach it to a form on a windows device? I have several microsoft surfaces, and I can't get the option to directly attach a picture to a form like you can with a phone, instead I have to open the camera app, take the picture, go into the form, and find the picture in…
-
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…