-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…
-
Group not totaling correctly
I have groups and sub-groups (I hope I'm using the right terminology, I have 8-rows indented under another row) and only the first four rows are totaling. The calculation is for Duration and I am using days and hours.
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Title characters
Is there a way to increase the character restriction in the column titles? I need this for the forms I am creating, they need to be longer in the column title to create the forms I need.
-
Check Flag with formula
I am trying to turn on a flag with a formula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get "true" and then turn the flags back on I get my red flags, but then I try it again in…
-
Unticked boxes to trigger reminder dates
In my project sheet, I have a Task Complete tick box. I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date. Is this possible?
-
Using check boxes and flags in formulas
In my project sheet I have checked boxes and flag. I would like to include them in my formulas. Example: If the box is unchecked by X date then the X date will appear in a reminder column.
-
How to create gauge graphs/speedometer graphs in smartsheet
Hi, Am looking for different options to create a dashboard and would like to create a gauge graph. Please advice on how I can do the same. Regards, Sachana