-
Assign Tasks to people without they having to see everyone elses task
I have created one master sheet with ask entire list of task with assigned to column. I want to create either new sheets or reports what every person has their own task list and they cannot see other people's task. Is it possible. In their own report or sheet they should be able to comment and add details to the columns…
-
How do I update my function syntax to stop getting the #INVALID DATA TYPE error?
I'm working within a sheet and trying to calculate the number of days between two dates. Above is a picture of what I'm seeing and my syntax is below. =NETWORKDAYS([Start Date]@row, [Date Completed]@row) I've tried to add IFERROR in a couple places and it didn't help with anything unfortunately. My Task Duration is set as…
-
From Web Excel Query and Smartsheet Publish Link
Hello - This is a bit of an Excel/Smartsheet question in truth. We have some workflows that depend on the From Web data function in Excel (Data -> From Web). We have switched our publish link to only be accessible to people on our account (instead of being published publicly), and the workflow now fails. I believe this is…
-
Full Edit Functionality in WorkApps
I put all the files I needed in WorkApps for efficiency, however, it could have been more efficient if we allow full edit functionality, for example, add columns, cell links etc, that do not require editing your sheets, reports, and dashboard at the Smartsheet application. The intention is to save time and increase…
-
Why is there an edit limitation while you use WorkApps?
I put all the files I need into Workapps (sheets, report & dashboard), only to find out that not all the edit functions when you use right click are available. I was trying to cell link but only a hyperlink is available when you edit your sheets at Workapps. Thought it would more dynamic and efficient, but seems like I…
-
Why does the symbol font has fixed size?
I am trying to make my RYG symbol a larger size (in my sheet, report & dashoard) but even if I changed it from for example font size 10 to 28, there is no difference in how it looks like. Is there anyone who can help or might have experienced the same and share what you did? Appreciate the responses. Thank you.
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
INDEX/Match Error?
Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…
-
Merged: Checkbox column SUM summary in Reports
This discussion has been merged.
-
Formula to always Summarize all 5 cells to the right of a column, including new columns added.
Hi, Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on? I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right. Thank you,
