-
Text vs duration and dependencies
Hello everyone, I need to create an easy to use sheet that will allow my team to choose a task type from a drop down list that then auto-populates an SLA column and from that works out overallocation of resources. So far I have tried to do a VLOOKUP from the task type to our SLA times but that comes across as a text entry…
-
Formula issues
Hello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, other value options are either a blank cell, or a status "Overdue". What I am trying to achieve is count how many times in…
-
Feature Request - Edit Scheduled Report Send Email
Under Report > Send as an Attachment it is possible to schedule a recurring email. It is also possible to edit the recurrence deliver options but not to edit the email itself. You have to delete the recurring email and start over. Could we please have the ability to edit that email message? Thanks, Nick
-
Pulling text through from other sheets
Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a risk that....) and a risk score (5). I understand cell linking but this won't work as the top 5 risk and issues will change on…
-
Reports
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Smartsheet to track our projects. This is a time suck on our company, so we are trying to directly have all of this on…
-
Share sheet as a copy - Consolidation
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually * I want to keep track of all the status of certain indicators for each…
-
Conditional Formatting not working?
Hi, all. As the attached shows, I have a rule to turn the whole row a color if the Task Name contains "S18 D1". But, only one row is colored? Am I doing something wrong? Thanks!
-
If x Then x in columns
Hello, Using drop down choices in columns, is there a way to take a column with a certain data value, & then in the following column, only certain choices appear in the drop down choices found there, out of many? Example: Entire set of Data consists of: A,B,C,1,2,3 Column 1: If you select A, only options 1 & 2 can be…
-
Nested IF Error - Incorrect Argument
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % column for a Project Tracker. Here is what I have: =IF([Status %]88 = 0, "Empty",…
-
SUMIF from one or more reference sheets
Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" column. Would I use VLOOKUP alongside SUMIF? Attached give you an idea of the breakdown. Thanks,
