-
Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
-
Webform - Changing color for healiners, email,
First request, it could be helpful to have the heading “Required Information” in red font so it stands out. Feedback from the Controllers reaching my desk indicates that xxx had to verbally point those out to the controllers, so please let’s work on rectifying that. Also, under “Required Information” the person submitting…
-
Update status field based on End date and %completion
Hello All, I would like to do some conditional updates in smartsheet based on below: 1) I want status field to reflect Green if End data of task is greater than today's date 2) I want status field to reflect Red if End data of task is less than today's date and % completion is less than 100%. 3) I want status field to…
-
Report not picking up all checked Star symbols
I am running a report and using a Star symbol to filter what should be picked up from my sheet. The report is picking up all rows with stars checked except one. I have confirmed this row is checked. I have removed the Star filter to show all data and it works just fine, picking up this row. But when I go back to filter by…
-
IF AND Formulas - Where am I going wrong
Morning All, I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please? I need the below: If today > actual start date & today is > actual end date & % complete < 100% = Red If today > actual start date & today is < actual end…
-
Tasks on Track and Off Track Count
Good Afternoon All, The Vice President has decided that for each project plan he wants to know the below information A count of the number of tasks that should be in progress (using start date) A count of the number of tasks that should have started and havn't (using % complete and Start date) A count of the number of…
-
Formulas that work across sheets
With no pivot table functionality & Reports having no aggregating functionality, and Sights having on wigdet capable of aggregating data we struggle to summarise or aggregate our data up. We could create a summary sheets that count/sum our data in other sheets IF Smartsheet allowed formulas across sheets (which it…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
Troubles with inputting a value for notification
I am creating a sheet to keep track of a budget process. I am curious why a notification does not get sent out when I input a value by typing it in when using the "is one of" condition? The notification only works when I already have 100% typed in the column somewhere, then I have to select it from the drop down box. Why…
-
Automated Email updates-- SUGGESTING MORE EFFICIENT FORMAT FOR COMMENTS
Hi All-- I LOVE SmartSheet but I really wish the AUTOMATED emails that are sent that include the COMMENTS section could be setup like the emails that can be sent from manually selecting the "send" function on a row; which places the message ON TOP of the row information. Said in a simpler fashion--PLEASE PUT THE COMMENTS…
