-
Alert based on row deletion
Hello All, Is there a way to setup an alert that has the following conditions: IF row on 'X' sheet is deleted by anyone but 'Y', sent alert to 'Z'. I thought about creating and alert that said if row is deleted alert 'Z' if 'modified by' is not 'Y'. It doesn't look like I can do this though as the work-flow parameters I…
-
V-axis showing 0 and 1 instead of %
In my chart, I am displaying %, and the chart is showing that in Series -> Data Labels, but the vertical axis is showing only "0" and "1". I would like the vertical axis to show the values given, those between 0 and 1, as a %. Your help is appreciated. Thank you.
-
How to PDF print multiple months in the Calendar APP?
Self explanatory hopefully from the title. I wanted to PDF print a full calendar year from the PDF print function in the calendar app. Unsure of how to do this as PDF print function only brings me to the view of current month in the App Thanks
-
sumif children and date criteria
Is there a way to get something like this to work? =SUMIF(Date:Date, >[Last Active Date]1, CHILDREN([Points]1)) Basically Date;Date has dates inserted in the range. Points has a point value I'm trying to get dates that are greater then the Last Active Date, and then add up the total Points if they meet the date & is a…
-
Smartsheet Forms
Getting ready to begin using Smartsheet forms and read a bunch of articles online about best practices. Two questions: * Is there any way to pull data from another aheet based on user input? For example, if user enters a course code (PPA 123, Smartsheet references another sheet to automatically display the course title. *…
-
% Complete
I created a bar chart in a widget on one of my dashboards, using % complete. The vertical axis lists values over 100%. How do I change this value? I don't like that it appears there is more work to be done, when the project phase reaches 100%. Any help or suggestions are welcome! Thanks, Courtney
-
Webform Submission issue
We are currently using our own custom WebForm to submit directly to Smartsheet. This process has been working flawlessly for the last few months. We had had users reporting now that when they hit submit on our php WebForm the old Smartsheet WebForm pops up and is completely blank. However if we go into Smartsheet, all the…
-
Smartsheet Examples/Real Spreadsheets
I've googled and haven't really found an answer. I'm looking for links to actual smartsheets, so i can see layouts and formulas etc. I'm not looking for customer testimonials, or samples, or templates or business cases, just different smartsheets
-
Days in year / Cal accounting for leap year
Hi Need to determine how many days in the current year (365 or 366) to be used in a calculation. Can anyway suggest how to determine how many days in the current year? Cheers Simon
-
Copy Action Items to separate list when identified in Meeting Minutes
We are capturing individual action items with a checkbox in our meeting minutes sheet. Once actions are identified, we're using the "Link from cell in other sheet" to pull the data from the meeting minutes sheet and into the action items sheet. Since this is a manual step, we'd like to simply check the action items box in…
