-
Formula help - set values for current user and date when check box checked
I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible. I see where I can use test the value of a checkbox and make it do things.. but what I want to do is get the current date and current user. So that when someone clicks…
-
IF THIS AND THIS then TRUE CHECKBOX
Since Smartsheets currently doesn't have timestamping system I am using manual dates to do so however I need a checkbox to be ticked to alert me when two conditions have been met. These conditions are dates and are blank before data goes into them. What I thought would work is =IF(AND([Date1]1 > 0, [Date2]1 > 0), TRUE )…
-
If Statement & Dropdown List
I have a dropdown list with 5 values and inserted an IF statement into the cells for that column to auto-fill 1 of the 5 values. I noticed when doing this you can no longer access the drop down list. Is there a way to auto-fill so the cell isn't blank to start but still allow users to access the 5 values in the list?
-
Date Formulas
I need to keep track of the day an item is approved. Is there a formula that I can use to generate a date that a check box is checked off?? Tiare
-
Sending notifications to a specific user for any row changes
Hi, I want to send email/mobile notifications to only the "Assigned To" person when anything (including attachments/discussions) changes for that particular row. Please think of this scenario where a particular task is assigned to a specific resource. Now any changes to that task need to be notified to only that resource…
-
Stringing Logical Arguments
Hello, I have been struggling with this formula for a few days now and can only get bits and pieces of it to work. So I am hoping I can get some help here. Essentially I am trying to create a formula that includes 5 fields and depending on what is in them, give me three possible outcomes. The fields I have are: 1.…
-
Create percentage complete based of boxes checked
Hello, I am very new to smartsheet and still quite inept. I have a smartsheet that I am using to track a student I am mentoring. There is a coumn titled 'Completed'. This allows the student to check when a specific task is complete. I want to be able to show the percentage complete based off how many boxes are checked as…
-
PLANNED VERSUS ACTUAL PROGRESS
hi, is there a way that i can see the planned versus actual progress of the project ? baseline versus actual? thanks.
-
Difference in Days between Projected & Actual Start Dates/ End Dates?
My managers want a column that calculates number of work days (Mon. - Fri) between Projected Start Date and Actual Start Date. Example: Projected Start Date (in Column A): 09/01/16. Actual Start Date (in Column C): 09/09/16. Difference in Days between projected and actual start dates (Column B) : 6 Days. What formula would…
-
Using a formula =CONTACT wont populate actual contact info subtasks
Help! At the top of my projects, I am including the resources involved. I'd like for subtasks to be auto-populated when I fill in a resource. Example: in my resources section, I set the HL7 Engineer to Joe Downing. I have it set so all HL7 tasks then populate with Joe Downing. PROBLEM: Joe Downing's contact info doesn't…
