-
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…
-
Gantt view on a dashboard report
I'm trying to include a report with it's corresponding Gantt chart on a dashboard. The report is set to open on today's date. However, in the dashboard the Gantt chart starts in June and I can't even scroll back to today's date (see attached snapshot). Can anybody help? Thank you.
-
SUMIFS using Fiscal Year Date Range
I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19. Here's the start of my formula that sums all dates, but what conditional formula do I need to add that…
-
How to convert dates to Long Form Date format?
I understand that date formatting is normally set in "Personal Settings" but in order for the SmartSheet Merge to work for a problem I'm trying to solve, I need to convert the date to the long form (February 11th, 2016 instead of 11/02/16. Is there a script or IF statement that I could use to make the change? Thanks, SRC
-
IF COLLECT / MATCH COLLECT / INDEX COLLECT / VLOOKUP ?
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS. If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level…
-
Vlookup + sum in a column
I am creating a template for keeping track of employee's leave. Column "Accumulated Leave" has the vlookup function to return the "leave days" taken by employees. the formula I have is as below: =VLOOKUP([Employee Name]3, $[Employee Name]8:$Duration50, 5, true) However, when I show the same employee on an another row, it…
-
using start and end time columns to calculate hours worked for a timesheet page
i am trying to track staff hours by having them complete a web form to auto submit their timesheets. i need to be able capture start and end times for any given day so i can check how many hours they have worked. any suggestions?
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
-
Setting Up Rules
Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of my team update the Recruitment Status for a vacant role to show 'Offer Made' I would like a prompt set up to automatically…
-
Formula help for my dashboard
Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show how many active roles each team member has on the go. However, I only want to select…