-
IF statement with NETDAYS
I am trying to use the following formula from Excel - =IF(ISBLANK(C2),DAYS360(B2,D2),DAYS360(B2,C2)) with NETDAYS so that I can count days from Admit to Release, or if Release is blank, Date Today. I tried =IF(ISBLANK Release@row, NETDAYS (Admit@row,[Date Today]@row), NETDAYS (Admit@row,Release@row))
-
Sharing Reports
Is there any way to share information on a report without giving employees access to the sheet it's connected to. This main sheet uses forms and may carry confidential information and I don't want them to view the full details of the sheet, just a few important key items on a report. Is this possible? This is in regards to…
-
recruiting conversion metrics
I'm looking to connect with anyone using smartsheet for tracking recruiting conversion metrics! My team currently uses sheets for tracking all candidate submittals and feedback between recruiters/HMs. Has anyone created a report or sheet to track the funnel conversion metrics from submission to hire?
-
Send form response
I would like to send/print my form with completed responses. Just sending/printing the row does not work, as the form has more information than the column names - is this possible?
-
Dependency Logic
I wonder: Is 'Row A' predecessor to any other? Which rows? Is there a formula that will accomplish this? -J
-
View Sent Alerts and Reminders in Activity History
Hi Brilliant Folks, I have an alert set-up that was working but suddenly stopped. I reached out to Smartsheet with two questions: * Is it possible to view the history of sent alerts? * Why would an alert just stop working when nothing has changed in set-up, column names, etc.? I was provided this a response: Our Activity…
-
Indenting sub-sub-tasks remove Gantt bars (start and finish dates)
Adding sub-tasks to a task seems to be no problem, perhaps because they are already indented. Indenting these sub-tasks removes all the start and finish dates for the rest of the sheet. Is there a way to avoid this and preserve the Start and f=Finish dates, thereby saving the Gantt chart? One way is to copy and past the…
-
Extract Date from Sentence
I have a description field for a product that has a start and end date in it. I am trying to extract the Start Date and End Date to put into separate fields in Month/Day/Year format. Example Description: RHEL SVR STANDARD PHYSICAL OR VIRTUAL NODES Comment: 11471579 Start Date 08/30/2019 End Date 08/29/2020 Thanks, David
-
Formula help
Hi, I am trying to count the total in a range on another sheet if entries fall within a certain date range (30 days) and are a specific name "Missed Hours" I have the following formula but cant get it to work: =SUMIFS({Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk Range 2}, "Missed Hours",…
-
Workflow that Generates a report for signing
Hi, We have built a form that creates a record for a client hand over inspections but it needs signing. We currently have adobe fill in and sign. What is the best way to get the form into the ipad app to have the client sign? Can i create a workflow that automatically emails a pdf report for the record to the users email…
