-
Can "@row" be used in the Intake Sheet Summary page calculation?
Hi, Just need a sanity check please. Can @row be used in the Intake Summary page calculation? I assume it won't work because it is a summary. However, [field]x:[field]xx (where x is the first row to consider and xx is the last) works.
-
Summary Sheet Formula and Milestone / Key Task Gantt
Hello community, I am new to using the smartsheet so hoping you can help me with the below. How can I update this fomula that I am planning to use in my Summary Sheet so that it only includes count of tasks that has a start date of in the future. I want to exclude those from my count. I consolidated 3 projects into one…
-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!
-
Creating a report with data from 3 different sheets
Hello! I'm new to Smartsheet and I need some help building the following two reports: I have 3 sheets, with the following main collumns: Sheet 1: Open Matters, containing #Matter, Client, Matter Type Sheet 2: Invoices, containing #Matter and Amount Received (Revenue) Sheet 3: Expenses, containing #Matter, Contractor,…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
-
Creating A Report of Missing Submissions
Hi Community! I have a form deployed to community partners. These partners need to submit a report 1x per month. Of course, some do not submit the monthly report. Is there a way for me to create a report of missing submissions? I have a reference of all partners who should be submitting a report and the sheet from the form…
-
Need to be able to organize summary sheet data for dashboard widgets
I have over 100 sheet summary data sets that I have nicely organized on the main smartsheet I'm pulling data from. However, when I try to set up widgets using the same data, there is no rhyme or reason to how they are organized. It's not even alphanumerical, so I have to go searching for all the matching sets. For example,…
-
Suggested Sheets - Update more frequently or in real tme
I notice when I update a sheet, and it appears on my suggested sheet, the preview is not updated. I was told that only occasional screen grabs are taken, and it looks like my sheet is not current, when in fact, it is, giving me problems with the boss.😫 I think the suggested sheets should be updated as well, in real time,…
-
Summary of Project and Phase Allocation % for each resource
I am trying to create a section at the top of the projects Gantt that shows the total allocation % for each resource in each project phase and in the project overall. I need this to not double count in resource manager, but just roll up each resource's allocation % from a Phase and the project in total. I've tried adding…
-
How do I gather and display info for this dashboard widget?
Hello Everyone! I have a dashboard that is tracking the progress of several projects. My audience had requested a visual representation of where each project is in the PM Phases Initiation, Planning, Execution, Monitor and Control, Closure I have created a sheet summary report that shows in words where each is is but they…