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 c…
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…
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 fi…
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 …
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 …
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 rep…
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 reaso…
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, whe…
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 i…
Hi, I have created a Sheet Summary Report which pulls data from the Summary tab of multiple source sheets. Nothing easier, right?? But, I can't see any way to center-justify the data in the report (be…