-
Network Days + If statements
Hello, I'm trying to build a formula that will show the network days between a [Start Date] and an [Completion Date], but also 1) if [Start Date] is blank, then return a blank instead of an #Invalid Data Type error; and also 2) if [Completion Date] is Blank, the formula subtracts the [Start Date] from Today(), so that we…
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…
-
How to record a date in a gantt?
Hi, I have a question about the Gantt chart. I want to record a date (start date) when a row is added. This will ensure that when a row is added to the Gantt chart, the start date is recorded at the beginning of the Gantt chart, and the other dates are automatically calculated. Is this possible? Regards
-
Smartsheetへのアクセスについて
他者から送られてきたリンクから，Emailアドレス，コードを入力しSmartsheetにアクセスした所，以下のメッセージが出てしまいました。Workspaceやシートの作成などをする予定はなく，ある記載を確認または変更するのみですが，どのようにしたらよいでしょうか？ 大変基本的なご質問で申し訳ありませんが，よろしくお願い致します。
-
Dynamic View Issues
Is anyone experiencing issues with Dynamic View? We have noticed the following over the last week or so: Slow load times Filters getting rearranged Some users not seeing updates made to the underlying report. Thoughts?
-
JOIN COLLECT formula for multiple successors
This discussion was created from comments split from: Return a task name that corresponds to the row in the predecessor column.
-
How to collect multiple Successor values?
Here's a link to my initial post which helped get me this far. RECAP: I use a combination of a Successor formula & Join/Collect in an attempt to report for my team the next tasks and assignee(s) in our waterfall workflow. I am able to successfully return the next assignee only when there is a single successor. I need to…
-
Help me brainstorm with my staffing calculation Issue.
Hi all, So, help me out here i'll state the facts and the current case here. I need a staffing calculation every hour per zone. Data is received every 15 minutes through a shuttle. Below you can see the current process. Don't mind the red square and mark. Data is being updated in box and moved to smartsheet with a data…
-
No longer able to attach file
I have had no problem dragging and dropping attachments on rows within my smartsheet until today, it just keeps saying "1 file failed to attach"
-
This is a question about multiple selection able to run report and auto counted and group in report
I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in multiple selection